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