Good Morning,
I am trying to use the following formula and I keep getting a #VALUE ! error:
AVERAGEIF(Firm1:Firm70!E46, "<>0")
I would like to get an overall average for a particular survey question, but I want to exclude zeros. I have each firm's submission in a separate tab. Any clue what I am doing wrong?
