AVERAGEIF to eliminate zeros

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?