average with some empty cells 1

[workshop]

how do I do average in column that has data but exclude the cell that don't have data?

Thanks in advance

 

[SkipVought]

Hi,

As long as the cells are empty and do not contain a zero, the AVERAGE function will only use values.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}