Thread: Suspend calc of formula using a non-existent sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
cvolkert
 
Posts: n/a
Default Suspend calc of formula using a non-existent sheet

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

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

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


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=489662

Reply With QuoteReply With Quote