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.

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.

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.

=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.

Can someone explain to me what exactly an array formula is?

"Bob Phillips" wrote:

=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.

Yes, Excel help can.
Type the words array formula into Excel help.
--
David Biddulph


sross002 wrote:
Can someone explain to me what exactly an array formula is?

"Bob Phillips" wrote:

=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.

See this:

http://www.cpearson.com/Excel/ArrayFormulas.aspx

--
Biff
Microsoft Excel MVP


"sross002" wrote in message
...
Can someone explain to me what exactly an array formula is?

"Bob Phillips" wrote:

=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.