Count rows based on calculation with their columns

[matyicsapo]

Hi,

I have 2 columns of dates. In column A a startdate and in column B an enddate and I have to count those rows in which the difference between the 2 is say 100 days.

Naturally I can fill a 3rd column with the difference between the 2 dates and use a very simple formula to count those with a value of 100.
I don't want to do that.

I'm not exactly sure whether it's possible to do it without an explicit helpcolumn, but I'd expect it not growing up with Excel exactly.
In any case, thanks for any help / tips in advance!

matyicsapo

[benishiryo]

hi matyicsapo, welcome to the forum. assuming your data is in A1:B10, try:
=SUMPRODUCT(--(B1:B10-A1:A10=100))

if you are looking for greater than or equals to 100, then:
=SUMPRODUCT(--(B1:B10-A1:A10>=100))

[matyicsapo]

Great! Thank you very much! Now I finally understand such formulas too :D