ExcelBanter - Returning a zero value in an average total

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Returning a zero value in an average total (https://www.excelbanter.com/excel-programming/387366-returning-zero-value-average-total.html)

chedd via OfficeKB.com

Returning a zero value in an average total

Hi

I wish to return a zero value in the total cell when there is no data in the
column cells. At present it is showing #DIV/0! in the total cell. The
formula i am using at the moment is =AVERAGE(B6:B24). Please can help with
this query.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

Mike

Returning a zero value in an average total

Try this.

=IF(SUM(B6:B24)0,AVERAGE(B6:B24),0)

Mike

"chedd via OfficeKB.com" wrote:

Hi

I wish to return a zero value in the total cell when there is no data in the
column cells. At present it is showing #DIV/0! in the total cell. The
formula i am using at the moment is =AVERAGE(B6:B24). Please can help with
this query.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1

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