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.
Bookmarks