Creating If Statement not to include if O in average
Mike-
I am running into issues on the bottom of the spreadsheet.
I am now pulling the data by quarters and it does not like the Zeros
I am now getting the #DIV/0!
1st Quarter 141 (Jan-Mar Data) =AVERAGE(IF(C10:E10<0,C10:E10,FALSE))
2nd Quarter 131 (Apr - Jun Data) =AVERAGE(IF(F10:H10<0,F10:H10,FALSE))
3rd Quarter 126 (Jul - Sept Data) =AVERAGE(IF(I10:K10<0,I10:K10,FALSE))
4th Quarter (all zeros) =AVERAGE(IF(L10:N10<0,L10:N10,FALSE)) (ERROR
message #div/0!)
Year to date: =AVERAGE(IF(B32:B35<0,B32:B35,FALSE)) (ERROR message #div/0!)
"Mike H" wrote:
Read my first reply again and enter the formula as an Array
Mike
"C Kreig" wrote:
Mike-
Thank you for your help, however I did this and now I get the #Value.
Please advise.
"C Kreig" wrote:
Good afternoon!
I have a spreadsheet that includes all 12 month, however when it figures the
yearly average I do not want it to include it when it does the average. I
have posted the formula below. Can you please help me figure this out.
=IF(C10=0,"0",AVERAGE(C10:N10))
Thank you in advance for your help.
|