0
12
15
0
13
15
0
0
How do I average these cells without counting the zero...I should come up with the average of 13.75
0
12
15
0
13
15
0
0
How do I average these cells without counting the zero...I should come up with the average of 13.75
=averageif(a1:a8,">0")
Ben Van Johnson
Assuming in column A
=SUM(A1:A20)/COUNTIF(A1:A20,">0")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks