Counting cells with text

C

Cissy

I have a sheet with branch names and answers to four survey questions.
I'm trying to use the formula counta(if(a3..a32,"Deltona",j3..j32). Th
formula works when the range a3..a32 is reduced to one cell.

I want to count only those cells that have an answer for "Deltona" i
each of the four questions.

Can anyone assist
 
D

Debra Dalgleish

You can use the Sumproduct function to count entries in column J where
there's "Deltona" in column A:

=SUMPRODUCT(--($A$2:$A$32="Deltona"),--($J$2:$J$32<>""))
 
Top