Suspend calc of formula using a non-existent sheet

[mikeburg]

I have the following formula in cell K6 of a sheet:

=SUMIF(DailyChargeLastMo!B$6:B$88,"="&A6,DailyChargeLastMo!D$6$88)

However, until I create the sheet DailyChargeLastMo I get a referenc
error for cell K6 as well as all other cells with formulas using dat
from K6.

Is there a way to make the above formula in K6 work only when the shee
DailyChargeLastMo is created?

Thanks for any & all help. mikebur

 

[cvolkert]

Here's one that I think will work, maybe not the best solution though .
.. .

=IF(ISERROR(SUMIF(DailyChargeLastMo!B$6:B$88,"="&A6,DailyChar
geLastMo!D$6$88)),0,SUMIF(DailyChargeLastMo!B$6:B$88,"="&A6,DailyChar
geLastMo!D$6$88))

Let me know if this doesn't work of if you're looking for something
different - Chad

 

[Max]

Perhaps try an error trap which returns zero as the value_if_true (as there
are downstream cells pointing to K6):

Put instead in K6:

=IF(ISERROR(SUMIF(DailyChargeLastMo!B$6:B$88,"="&A6,DailyChargeLastMo!D$6$
88)),0,SUMIF(DailyChargeLastMo!B$6:B$88,"="&A6,DailyChargeLastMo!D$6$88))

 

[mikeburg]

Works great. Thanks so very, very much. mikeburg

 

[Max]

You're welcome, and thanks for the feedback !
Chad, the other responder, and I thought alike
(But his thoughts came through first <g>)