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