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
If B2, D2 and F2 contain text values, try this.....
And if B2, D2 and F2 may also contain numbers, try this simple approach.....
=SUMPRODUCT(--(ISNUMBER(A2:G2)),A2:G2)/SUMPRODUCT(--(ISNUMBER(A2:G2)),--(A2:G2<>0))
=SUM(A2,C2,E2,G2)/SUM(IF(A2<>0,1,0),IF(C2<>0,1,0),IF(E2<>0,1,0),IF(G2<>0,1,0))
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Or
=SUM(A2,C2,E2,G2)/INDEX(FREQUENCY((A2,C2,E2,G2),0),2)
Marcelo Branco
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks