Average Formula
Try something like this:
=AVERAGE(IF(F5:F10000,F5:F1000))
this is an array formula so enter using Ctrl+Shift+Enter
HTH
Jean-Guy
"sross002" wrote:
how do I Calculate the average of numbers not in a contiguous row or column,
excluding cells that have 0?
(The column starts at F5 but I will continuosly add to the f column, so it
doesn't have an ending column.)
It's a simple worksheet calculating my MPG on my car, so I will keep adding
to it.
|