Counting cells with text
 

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). The
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" in
each of the four questions.

Can anyone assist?


--
Cissy
------------------------------------------------------------------------
Cissy's Profile: http://www.excelforum.com/member.php...o&userid=20107
View this thread: http://www.excelforum.com/showthread...hreadid=560177

Counting cells with text
 

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<""))

Cissy wrote:
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). The
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" in
each of the four questions.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html