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

--
Ciss
-----------------------------------------------------------------------
Cissy's Profile: http://www.excelforum.com/member.php...fo&userid=2010
View this thread: http://www.excelforum.com/showthread.php?threadid=56017

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