count if and

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

I am trying to count based off of two criteria's.

In cells ($D$3:$D$3536="C") and ($J$3:$J$3536<>"") I would like a formula
that counts the number of cells that meets both criteria.

I appreciate your help!
 
Do you have any N/A's in either of the two ranges?

Did you change the formula? If yes, then post what you used.
 
Hi Dave,

I did have a few N/A's and after removing them it worked fine!

Thank you for your help*
 
Back
Top