Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suspend calc of formula using a non-existent sheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suspend calc of formula using a non-existent sheet
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,"="&A 6,DailyChargeLastMo!D$6:D$ 88)),0,SUMIF(DailyChargeLastMo!B$6:B$88,"="&A6,Dai lyChargeLastMo!D$6:D$88)) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "mikeburg" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suspend calc of formula using a non-existent sheet
Works great. Thanks so very, very much. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=489662 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Suspend calc of formula using a non-existent sheet
You're welcome, and thanks for the feedback !
Chad, the other responder, and I thought alike (But his thoughts came through first <g) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "mikeburg" wrote in message ... Works great. Thanks so very, very much. mikeburg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link cells, sheet to sheet, to recognize row deletions? | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Change sheet name in formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |