Averaging in Execl
Averaging in Execl
(OP)
When using Quattro Pro, I can use a function "PureAverage" to average a series, even if some cells of the series contain unsatisfied formulas. "PureAverage" ignors these cells and averages the remaining cell values. Does Excel have a similar function??
Steve Wagner
Stiffler, McGraw & Assoc.
Hollidaysburg PA
Steve Wagner
Stiffler, McGraw & Assoc.
Hollidaysburg PA





RE: Averaging in Execl
good luck!
-pmover
RE: Averaging in Execl
I think :)
Thanks!!!
Steve
RE: Averaging in Execl
RE: Averaging in Execl
1 1
2
3 3
4 1
5 5
6 1
7 7
8 1
9 9
10 1
average 3.222222222
count 9
sum 29
TTFN
RE: Averaging in Execl
Steve
RE: Averaging in Execl
If your friend uses the COUNT function, it ignores the blank cells, so the fact that you added a bunch of zeros is irrelevant. The only reason it's screwing up is because your friend is explicitly defining the number of items to average.
TTFN
RE: Averaging in Execl
It seems to come down to the fact that Quattro treats blank cells as blank (and won't complete a calculation) while Excel treats blank cells as zero.
Sometimes the data actually is a zero, so checking for zero won't work.
Steve
RE: Averaging in Execl
RE: Averaging in Execl
=SUM(A1:A7)/COUNTIF(A1:A7,">0")
Where ALL data (including 0's) is in cells A1 to A7
RE: Averaging in Execl