Average Formula
=ROUND(AVERAGE(IF(F5:F10000,F5:F1000)),2)
still array-entered.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"sross002" wrote in message
...
that worked great!!!
The formula reads like this: =AVERAGE(IF(F5:F10000,F5:F1000))
How would I go about rounding it two decimal places?
"pinmaster" wrote:
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.
|