If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#DIV/O error
I have a workbook with several indiv. sheets totalling to
one sheet for a dept. total. Columns are set up in weeks with a monthly total column as well. I would like to get a running average of data in the monthly total column but keep getting #DIV/0 since not all weeks are complete on sheet. Is there any way around this? I'm using a simple average calc. : =AVERAGE(C12:G12) HELP! |
#2
|
|||
|
|||
#DIV/O error
Hi
try =IF(COUNTA(C12:G12)0,AVERAGE(C12:G12),"") -- Regards Frank Kabel Frankfurt, Germany Karen wrote: I have a workbook with several indiv. sheets totalling to one sheet for a dept. total. Columns are set up in weeks with a monthly total column as well. I would like to get a running average of data in the monthly total column but keep getting #DIV/0 since not all weeks are complete on sheet. Is there any way around this? I'm using a simple average calc. : =AVERAGE(C12:G12) HELP! |
#3
|
|||
|
|||
#DIV/O error
Thanks for your help, it didn't work though. I'll keep
racking my brain! In the formula below can you explain how the program looks at ""? Is it considered 0 or blank? Number or text? -----Original Message----- Hi try =IF(COUNTA(C12:G12)0,AVERAGE(C12:G12),"") -- Regards Frank Kabel Frankfurt, Germany Karen wrote: I have a workbook with several indiv. sheets totalling to one sheet for a dept. total. Columns are set up in weeks with a monthly total column as well. I would like to get a running average of data in the monthly total column but keep getting #DIV/0 since not all weeks are complete on sheet. Is there any way around this? I'm using a simple average calc. : =AVERAGE(C12:G12) HELP! . |
Thread Tools | |
Display Modes | |
|
|