Linking Workbooks

[Metcare]

Hi,
Appreciate any help.
I have 3 workbooks created for 3 depts who are responsible in putting in
data monthly. I created a summary workbook that averages (via linking and
AVERAGE formula) the data for the 3 workbooks. However, since some of the
month's data are not filled up yet, the #DIV0 is being displayed on the data
in my summary workbook.
How do replace the "# DIV0" values with dash(-), so it would not look like
an error.

Here's the formula for my AVE in the summary workbook:

" =AVERAGE('C:\My
Documents\SCORECARDS\Aug_2008\[WOC_OB_Scorecard.xls]Metcare_OB'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_PO_Scorecard.xls]Metcare_PO'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_NSB_Scorecard.xls]Metcare
NSB'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_BNL_Scorecard.xls]Metcare_Bunnell'!$M$10)"

 

[Dave Peterson]

=if(count(allthosecells)=0,"-",average(allthosecells))

Hi,
Appreciate any help.
I have 3 workbooks created for 3 depts who are responsible in putting in
data monthly. I created a summary workbook that averages (via linking and
AVERAGE formula) the data for the 3 workbooks. However, since some of the
month's data are not filled up yet, the #DIV0 is being displayed on the data
in my summary workbook.
How do replace the "# DIV0" values with dash(-), so it would not look like
an error.

Here's the formula for my AVE in the summary workbook:

" =AVERAGE('C:\My
Documents\SCORECARDS\Aug_2008\[WOC_OB_Scorecard.xls]Metcare_OB'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_PO_Scorecard.xls]Metcare_PO'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_NSB_Scorecard.xls]Metcare
NSB'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_BNL_Scorecard.xls]Metcare_Bunnell'!$M$10)"

 

[Metcare]

Thanks a lot, it worked.

=if(count(allthosecells)=0,"-",average(allthosecells))

Hi,
Appreciate any help.
I have 3 workbooks created for 3 depts who are responsible in putting in
data monthly. I created a summary workbook that averages (via linking and
AVERAGE formula) the data for the 3 workbooks. However, since some of the
month's data are not filled up yet, the #DIV0 is being displayed on the data
in my summary workbook.
How do replace the "# DIV0" values with dash(-), so it would not look like
an error.

Here's the formula for my AVE in the summary workbook:

" =AVERAGE('C:\My
Documents\SCORECARDS\Aug_2008\[WOC_OB_Scorecard.xls]Metcare_OB'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_PO_Scorecard.xls]Metcare_PO'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_NSB_Scorecard.xls]Metcare
NSB'!$M$10,'C:\My
Documents\SCORECARDS\Aug_2008\[WOC_BNL_Scorecard.xls]Metcare_Bunnell'!$M$10)"