I'm having trouble changing my formula in a table. My current equation is =SUMPRODUCT(([US11UsageReorderPoint.xlsx]Sheet1!$B$2:$B$2187 = C3) * (US11UsageReorderPoint.xlsx!DATA10))

I've added rows to the table and tried to increase the range from Data10 to include to new rows. When I do this I get a #N/A error. Any suggestions?