I have the following formula in cell K6 of a sheet:
=SUMIF(DailyChargeLastMo!B$6:B$88,"="&A6,DailyChar geLastMo!D$6:D$88)
However, until I create the sheet DailyChargeLastMo I get a reference
error for cell K6 as well as all other cells with formulas using data
from K6.
Is there a way to make the above formula in K6 work only when the sheet
DailyChargeLastMo is created?
Thanks for any & all help. mikeburg
--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
View this thread:
http://www.excelforum.com/showthread...hreadid=489662