count matched cells

  • Thread starter Thread starter KB
  • Start date Start date
K

KB

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!
 
Assming there are no empty cells...

Try something like this:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Counting # of Formulas in a column with formulas and entered data 1
"If" function question 3
countifs Function not giving desired result with date criteria 2
Excel Sumproduct 0
If certain date is past certain date. 3
calculate percent met (comparing 2 date columns) 2

Back
Top