count if and

[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!

 

[Teethless mama]

SUMPRODUCT(($D$3:$D$3536="C")*($J$3:$J$3536<>""))

 

[tom]

Thank you for the quick response, but it returns #N/A

Any ideas?

 

[Dave Peterson]

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.

 

[tom]

Hi Dave,

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

Thank you for your help*