Hi
how are your sheets named. That is do they follow a numbering rule,
etc.

--
Regards
Frank Kabel
Frankfurt, Germany

"Hagge" schrieb im Newsbeitrag
...
I have a workbook with several sheets where I need to have the sum
from all
column d when the criteria in columns c matches a criteria in d12 on
my
"mastersheet". I can add a sumif for every sheet but it seems to be
unnecessary with you guys around. Also I do not want to edit the
formula
every time I add a new sheet. Can you please give me an advice?