Using average command with a 0 in the column
 

Hi,

I'm trying to average a column where 0 is one of the numbers.

However, if the column has three numbers and one is a 0, the numbers are
being averaged by two, not three.

For example. 34 + 0 + 42 =76 and I'm getting a result of 38 when it should
be 25.3.

How do I get Excel to recognize the 0 as an actual number?

Thanks.

Using average command with a 0 in the column
 

Just be sure that the zero is a "real" zero. Not a blank or a text string.

AVERAGE() ignores blanks and "false" zeros.
--
Gary's Student


"jlandes84" wrote:

Hi,

I'm trying to average a column where 0 is one of the numbers.

However, if the column has three numbers and one is a 0, the numbers are
being averaged by two, not three.

For example. 34 + 0 + 42 =76 and I'm getting a result of 38 when it should
be 25.3.

How do I get Excel to recognize the 0 as an actual number?

Thanks.

Using average command with a 0 in the column
 

It works for me.
Are you sure that your zero is actually a zero, and not a cell with a text
string (perhaps including spaces or otgher non-printing characters), and not
a capital O? Is the cell a straight data value, or the result of a formula?
What formula are you using for the average? Is it =AVERAGE()? Are you sure
you're including the correct cells? What happens if you replace the zero
temporarily with 0.001 or something? Does it get included in the average
then?
--
David Biddulph

"jlandes84" wrote in message
...
Hi,

I'm trying to average a column where 0 is one of the numbers.

However, if the column has three numbers and one is a 0, the numbers are
being averaged by two, not three.

For example. 34 + 0 + 42 =76 and I'm getting a result of 38 when it should
be 25.3.

How do I get Excel to recognize the 0 as an actual number?

Thanks.

Using average command with a 0 in the column
 

Yep, you guys were right. Thanks.

However, this presents another problem. It is an actual zero and it's
averaging correctly on the top table.

But there are four more tables below where I set them up in August and
forgot one of the formulas that I used: =AVERAGE(IF(F28:F35<0,(F28:F35)))
due to linking various parts of the top table to some or all of the bottom
four tables.

To make a long story short, say you have eight entries. Six have
automatically entered data (numbers in this case) by what was inputed in the
top table. The last two rows are all showing zeroes, of course, because the
data has yet to be completed above. But, of the six that have been entered,
one IS a zero and it is not being averaged and needs to be.

Any ideas?

Thanks again.

Using average command with a 0 in the column
 

The last two rows show 0 because of a formula that is reading the top
table? Maybe you can modify this formula to show "" instead of 0 when
no data have been input yet.

Somehow you need to distinguish otherwise, not with 0. Maybe some
labels with months? This all depends on your top table data and your
formulas.

HTH
Kostis Vezerides

jlandes84 wrote:
Yep, you guys were right. Thanks.

However, this presents another problem. It is an actual zero and it's
averaging correctly on the top table.

But there are four more tables below where I set them up in August and
forgot one of the formulas that I used: =AVERAGE(IF(F28:F35<0,(F28:F35)))
due to linking various parts of the top table to some or all of the bottom
four tables.

To make a long story short, say you have eight entries. Six have
automatically entered data (numbers in this case) by what was inputed in the
top table. The last two rows are all showing zeroes, of course, because the
data has yet to be completed above. But, of the six that have been entered,
one IS a zero and it is not being averaged and needs to be.

Any ideas?

Thanks again.