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))
Create a column that has a function to perform the comparison, e.g. =A1 > B1
. This will give you a column that contains TRUE or FALSE for your comparison. Then you can use the COUNTIF function to count the results of this function, e.g. =COUNTIF(C:C, "=TRUE")
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With