Help with AverageIf function

[rcarruth]

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

[sktneer]

If B2, D2 and F2 contain text values, try this.....

Please Login or Register  to view this content.

And if B2, D2 and F2 may also contain numbers, try this simple approach.....

Please Login or Register  to view this content.

[mlcb]

Or

=SUM(A2,C2,E2,G2)/INDEX(FREQUENCY((A2,C2,E2,G2),0),2)