Counting cells with text

  • Thread starter Thread starter Cissy
  • Start date Start date
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
 
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<>""))
 

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

Another Array Mystery 4
Indirect and Sheet Name 4
count 3
if statements 6
If Statement 2
Calculating cells with text only 1
Count with various type 2
Count cells 1

Back
Top