You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"KB" wrote in message
...
Perfect! Thanks so much!

"T. Valko" wrote:

Assming there are no empty cells...

Try something like this:

=SUMPRODUCT(--(A1:A10=B1:B10))

--
Biff
Microsoft Excel MVP


"KB" wrote in message
...
I have a tracker with 1 of the columns being the requested due date &
one
is
the actual completed date. I need a formula that will compare these 2
cells
in the row & calculate how many times the due date was met.
So in cell A1 I have a running total of how many projects met the due
date.
Is there a countif formula for this?
Thank you!