I have a spreadsheet with branches and survey answers to calculate. I
want to only count the cells containing text in a certain range for
each branch. The formula I'm trying to use is =counta(if(a2..k58="Port
Malabar",j2..k58)). I keep getting a value error.

I appreciate anyone's help with this.


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