Maybe

=SUMPRODUCT(SUMIF(INDIRECT("'1251 Beta'!$B$10:$B$38"),'RESOURCE
ALLOCATION'!$B61)*(INDIRECT("'1251 Beta'!C$10:C$38")))


--
__________________________________
HTH

Bob

"Jennifer" wrote in message
...
I am using SUMPRODUCT to calculate across 30 different spreadsheets. I
finally have it working so that it will go to a spreadsheet and lookup an
identifier and return a value assocated with that identifier. The problem
is
if I add a new row to one of the sheets, it messes up my summary page. I
have even ensured the new row has the correct data and no blanks. What
can I
do to protect the SUMPRODUCT even if I add a new row to a spreadsheet

Here's a sample of my formula
Formula lives on Summary and I add a new row to '1251 Beta' sheet

=SUMPRODUCT(('1251 Beta'!$B$10:$B$38='RESOURCE ALLOCATION'!$B61)*('1251
Beta'!C$10:C$38))