using functions empty cells
 

If I have a column of data that contains some empty cells, how can I use
the average or var functions and have them ignore the empty cells?

I have seen this before but can't find it now so I am hoping someone can
point me to the correct way
Thanks
Chris

using functions empty cells
 

Hi Inquirer,

how can I use the average or var functions and have them ignore the empty
cells?

I think that Average and Var ignore empty cells, so use the functions 'as
is'.

---
Regards,
Norman

"inquirer" wrote in message
u...
If I have a column of data that contains some empty cells, how can I use
the average or var functions and have them ignore the empty cells?

I have seen this before but can't find it now so I am hoping someone can
point me to the correct way
Thanks
Chris

using functions empty cells
 

Some thoughts ..

If it's really empty cells, or cells with formulas evaluating to null
strings: ""
think the normal functions would suffice:
=AVERAGE(A1:A5)
=VAR(A1:A5)

If it could involve cells with zeros inputted, or cells with formulas
evaluating to zeros (perhaps the display of zeros have been suppressed ..),
then one way would be to use array-entered* expressions like:
=AVERAGE(IF(A1:A5<0,A1:A5))
=VAR(IF(A1:A5<0,A1:A5))
*entered via pressing: CTRL+SHIFT+ENTER
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"inquirer" wrote in message
u...
If I have a column of data that contains some empty cells, how can I use
the average or var functions and have them ignore the empty cells?

I have seen this before but can't find it now so I am hoping someone can
point me to the correct way
Thanks
Chris

using functions empty cells
 

Hi!

Both of those functions will ignore empty cells.

Biff

"inquirer" wrote in message
u...
If I have a column of data that contains some empty cells, how can I use
the average or var functions and have them ignore the empty cells?

I have seen this before but can't find it now so I am hoping someone can
point me to the correct way
Thanks
Chris

using functions empty cells
 

Biff wrote:
Hi!

Both of those functions will ignore empty cells.

Biff

"inquirer" wrote in message
u...

If I have a column of data that contains some empty cells, how can I use
the average or var functions and have them ignore the empty cells?

I have seen this before but can't find it now so I am hoping someone can
point me to the correct way
Thanks
Chris



Thanks for your comments.
The formulae Max gave were the ones I had seen before.
Chris