Excel - Returning only counts if two cells match

0
votes

I have the below test table in Excel. I am looking to be able to use the COUNTIFS formula (or another if able to) where it would only return rows if cells DATE1 and DATE2 match.

I cannot enter the dates directly into the formula as the dates can be any range up to 3 years ago. Any help would be appreciated.

Excel Test Table

2
excelexcel-formula

2 Answers

2
votes
=SUMPRODUCT(--(Table1[DATE1] = Table1[DATE2]))

Blanks can be ignored like this, but using the whole column is much slower:

=SUMPRODUCT( (A:A = B:B) * (A:A <> "") )
0
votes

Not sure what you're wanting to count but:

=if(A1=C1,do something, do something else)