Averaging only populated cells
Well, try it out. AVERAGE ignores blank cells, so your result should
not be adversely affected.
Pete
On Sep 19, 2:08*pm, John wrote:
I'm averaging cells that aren't next to each other, but i don't want the
average to include cells that aren't populated.
=AVERAGE(F4:F6,F10,F14,F18,F21)
f
F4- 5
F6- 5
F10-
F 14- 5
AVERAGE = 3.75 * *
for example, its possible that, let say, F10 has no quantitiy, i don't want
that to drag my average down. I want the results in the example above to
average = 5
|