列A中的Excel Countif日期大于列B [英] Excel Countif Date in column A is greater than column B
本文介绍了列A中的Excel Countif日期大于列B的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
谢谢。
解决方案
尝试这样:
= SUMPRODUCT( - (A:A> B:B))
它将对列 A
中的日期更大的范围内的所有实例进行求和而不是列 B
。
您也可以这样做,但需要作为数组公式输入( Ctrl + Shift + Enter
):
= SUM(IF A:A> B:B,1,0))
Columns A and B both have dates. If the date in column A is greater than the date in the same row of column B, the row should be counted. To add context, I am trying to count the number of rows where the completion date is past the due date. How can this be accomplished?
Thanks.
解决方案
You can try this:
=SUMPRODUCT(--(A:A>B:B))
It will sum all instances in the range where the date in column A
is greater than that in column B
.
You can also do this, however it needs to be entered as an array formula (Ctrl+Shift+Enter
):
=SUM(IF(A:A>B:B,1,0))
这篇关于列A中的Excel Countif日期大于列B的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文