Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
formula and delete sheet
0 views
Skip to first unread message
bijan
Nov 22, 2009, 8:35:01 AM11/22/09
to
Hi all,
I have sumif formula:
SUMIF(TST!F10:F20000;D2;TST!G10:G20000)
if i delete tst sheet my formula loss its refrences, how can i prevent ref!
error and formula returns zero if the sheet deleted
Thanks
Bijan
I have sumif formula:
SUMIF(TST!F10:F20000;D2;TST!G10:G20000)
if i delete tst sheet my formula loss its refrences, how can i prevent ref!
error and formula returns zero if the sheet deleted
Thanks
Bijan
Don Guillett
Nov 22, 2009, 8:58:54 AM11/22/09
to
You have it set to refer to the sheet you are deleting. What do you want it
to do???
to do???
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguil...@austin.rr.com
"bijan" <bi...@discussions.microsoft.com> wrote in message
news:4421D49C-E5DC-4C4A...@microsoft.com...
bijan
Nov 22, 2009, 10:07:01 AM11/22/09
to
Hi Don,
simply I want my formula in the active sheet shows zero if tst sheet is not
exist and if the tst sheet is exist it calculate the related data,
because the txt sheet created by query frequently
Many Regards
Bijan
simply I want my formula in the active sheet shows zero if tst sheet is not
exist and if the tst sheet is exist it calculate the related data,
because the txt sheet created by query frequently
Many Regards
Bijan
"Don Guillett" wrote:
> .
>
Dave Peterson
Nov 22, 2009, 10:58:05 AM11/22/09
to
=IF(ISERROR(CELL("Address",INDIRECT("'tst'!A1"))),0,
SUMIF(INDIRECT("'TST'!F10:F20000"),D2,INDIRECT("'TST'!G10:G20000")))
SUMIF(INDIRECT("'TST'!F10:F20000"),D2,INDIRECT("'TST'!G10:G20000")))
I use the comma for my list separator, you'll want to convert them to
semicolons:
=IF(ISERROR(CELL("Address";INDIRECT("'tst'!A1")));0;
SUMIF(INDIRECT("'TST'!F10:F20000");D2;INDIRECT("'TST'!G10:G20000")))
(I think I got them all!)
--
Dave Peterson
0 new messages