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))