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