Averageif ignoring zeros/blanks not working

[NickM88]

Hello,

I’m trying to use the averageif function to find the average of individual cells as a total, ignoring blank cells, but include zeros.

At the moment, I have this

=averageif(e9,k9,q9,w9,ac9,ai9,”<>0”)

However, the cells ac9 and ai9 don’t get selected and I don’t know why? Any help?

 

[NickM88]

Just to add, I am trying to have an average percentage for the week, hence why ignore blanks (as staff was not working) but include 0 (as could have got 0%)