I am trying to get an average of 4 cells in 4 different columns (A2,C2,E2 AND G2) and if one of the cells has a zero then ignore it.
For example:
A2=5
C2=10
E2=9
G2=0
the average would be 8
the way I've entered the formula is:
=AVERAGEIF(A2,C2,E2,G2,”>0”)
I keep getting the error "Too many arguements"
Where am i going wrong?
Thanks for the help
Bob
Bookmarks