SUMMING A CELL ACROSS MULTIPLE PAGES OF 1 WORKBOOK

[SMTH]

I HAVE A SPREADSHEET THAT SPANS 3 PAGES, CALLED
PAGE1,PAGE2,PAGE3.ON EACH PAGE THERE IS A VALUE IN CELL
C15 THAT SHOULD BE INCREMENTED BY THE VALUE FROM EACH
PAGE, THAT IS IF PAGE1 C15=10, AND PAGE2 C15=20, THE
CALCULATED VALUE OF C15 ON ALL PAGES SHOULD BE 30.
HOWEVER THE VALUE OF C15 ON EACH PAGE IS CALCULATED ONLY
IF THE VALUE OF H10 FOR EACH PAGE IS EQUAL TO 0.00.
THEREFORE ON PAGE1 IF H10=0.00 ,C15 ON PAGE1 IS
CALCULATED. IF H10 ON PAGE2 = 0.00 THEN C15 FOR PAGE2 IS
CALCULATED, BUT IF THE VALUE OF H10 ON PAGE3 IS NOT 0.00,
THEN C15 ON PAGE3 IS SET TO 0, AND THE ONLY PAGES ADDED
ARE THOSE WHERE H10=0.00 AND C15 ON PAGE3 IS SET TO 0 AND
NOT ADDED TO THE TOTAL VALUES CALCULATED ON PAGE1 AND
PAGE2. I WOULD LIKE TO USE THE SUMIF FUNCTION IF POSSIBLE.

 

[Jason Morin]

Please turn off your Caps Lock key. It makes your post
difficult to read and is considered "shouting".

To sum C15 when H10 = 0 across your worksheets:

=SUM(SUMIF(INDIRECT("Page"&{1,2,3}&"!H10"),0,INDIRECT
("Page"&{1,2,3}&"!C15")))

HTH
Jason
Atlanta, GA