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