ExcelBanter - If Statement not to include O when doing average

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

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

- - If Statement not to include O when doing average (https://www.excelbanter.com/excel-discussion-misc-queries/204504-if-statement-not-include-o-when-doing-average.html)

C Kreig

If Statement not to include O when doing average

Good afternoon!
I am working on a 12 month accumalative spreadsheet. When the sheet
calculates the average for the months it currently pulls the months that
contain a 0 in them. I would like this to only average the cells do not
contain 0's. I have pasted the formula below. Can you please help me with
this? Thank you in advance for your help.
=IF(C10=0,"0",AVERAGE(C10:N10))

Mike H

If Statement not to include O when doing average

see your first post

"C Kreig" wrote:

Good afternoon!
I am working on a 12 month accumalative spreadsheet. When the sheet
calculates the average for the months it currently pulls the months that
contain a 0 in them. I would like this to only average the cells do not
contain 0's. I have pasted the formula below. Can you please help me with
this? Thank you in advance for your help.
=IF(C10=0,"0",AVERAGE(C10:N10))

All times are GMT +1. The time now is 10:04 PM.