Dear Expert,
in below, i want to calculate average without 0 figure that means my average will be 7.812. i want to reduce 0 figure lines from average formula.
please help me.
CM
10.224
0
5.4
0
0
0
0
0
average=1.95
thanks
Wahid.
Dear Expert,
in below, i want to calculate average without 0 figure that means my average will be 7.812. i want to reduce 0 figure lines from average formula.
please help me.
CM
10.224
0
5.4
0
0
0
0
0
average=1.95
thanks
Wahid.
Try:
=AVERAGEIF(A2:A9,"<>0")
or can
Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
thanks all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks