If Statement and AVG help

[nacskins]

Hello all, looking for a little help. Currently using if statements and not getting what I need displayed. Currently have **** =IF((SUM(C5,C8,C11,C14,C17,C20,C23)=0),"",SUM(C5,C8,C11,C14,C17,C20,C23)) **** which works great, if the cells listed are blank then the display is left blank.... works great. Now I also have ***** =AVERAGE(C6,C9,C12,C15,C18,C21,C24)/1440 **** to which I also need to return a blank if nothing entered in cells listed. Seems like no matter what IF statement I use I get ***** #DIV/0! **** displayed when cells listed are blank. Any help is as always greatly appreciated.

 

[Jonmo1]

Try this if you have XL2007+

=IFERROR(AVERAGE(C6,C9,C12,C15,C18,C21,C24)/1440,"")

 

[Aladin Akyurek]

Hello all, looking for a little help. Currently using if statements and not getting what I need displayed. Currently have **** =IF((SUM(C5,C8,C11,C14,C17,C20,C23)=0),"",SUM(C5,C8,C11,C14,C17,C20,C23)) **** which works great, if the cells listed are blank then the display is left blank.... works great. Now I also have ***** =AVERAGE(C6,C9,C12,C15,C18,C21,C24)/1440 **** to which I also need to return a blank if nothing entered in cells listed. Seems like no matter what IF statement I use I get ***** #DIV/0! **** displayed when cells listed are blank. Any help is as always greatly appreciated.

Something like:

=IFERROR(AVERAGE(C6,C9,C12,C15,C18,C21,C24)/1440,"")

 

[nacskins]

Beautiful !!!! Thank you very much.... If you have the time I have a 3rd cell that has *** =SUM(C7,C10,C13,C16,C19,C22,C25)/1440 *** and is formatted to display time (h:mm) and if the listed cells are blank we get (0:00). Any suggestions on this to show blank instead?

 

[Aladin Akyurek]

beautiful !!!! Thank you very much.... If you have the time i have a 3rd cell that has *** =sum(c7,c10,c13,c16,c19,c22,c25)/1440 *** and is formatted to display time (h:mm) and if the listed cells are blank we get (0:00). Any suggestions on this to show blank instead?

=if(isnumber(1/sum(c7,c10,c13,c16,c19,c22,c25)),sum(c7,c10,c13,c16,c19,c22,c25)/1440,"")

 

[nacskins]

Thank you again! that works great also!

 

[Aladin Akyurek]

Thank you again! that works great also!

You are welcome.