averaging

[Alex]

Hi
If I want to obtain the average of values in a column, using only those
cells which have a value in them, which function do I use please?

thanks
A

 

[Dave Peterson]

Use =average()
it ignores cells that are empty and cells that contain text.