ExcelBanter - average when one or more cells are in blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - average when one or more cells are in blank (https://www.excelbanter.com/excel-discussion-misc-queries/198466-average-when-one-more-cells-blank.html)

Art

average when one or more cells are in blank

I have to average from B4 to B34 column but some of the cells are in blank
Which formula should I used?

Fred Smith[_4_]

average when one or more cells are in blank

=average(b4:b34)

It will disregard blank cells.

Regards,
Fred.

"art" wrote in message
...
I have to average from B4 to B34 column but some of the cells are in blank
Which formula should I used?

Teethless mama

average when one or more cells are in blank

=AVERAGE(B4:B34)

"art" wrote:

I have to average from B4 to B34 column but some of the cells are in blank
Which formula should I used?

All times are GMT +1. The time now is 09:13 AM.