I built a table to pull data and it works on my current sheet. i used this formula =SUMPRODUCT((table3[12 - How many appointments did you schedule today?])*(table3[1 - Hi, what''s your first name?]=$A2)*(table3[3 - What date are you reporting numbers for?]=$C2)*(table3[2 - Last name?]=$B2)) it pull the data over.

When i added new data i get this =SUMPRODUCT((#REF!)*(#REF!=$A2)*(#REF!=$C2)*(#REF!=$B2)) I did change the table name as well but that didn't change anything.


When i copy the working formula into to the sheet above with the #ref with updated data this is what i get.
=SUMPRODUCT(('Copy of Copy of Weekending Goal Preformance V.xlsx'!table3[12 - How many appointments did you schedule today?])*('Copy of Copy of Weekending Goal Preformance V.xlsx'!table3[1 - Hi, what''s your first name?]=$A2)*('Copy of Copy of Weekending Goal Preformance V.xlsx'!table3[3 - What date are you reporting numbers for?]=$C2)*('Copy of Copy of Weekending Goal Preformance V.xlsx'!table3[2 - Last name?]=$B2))

Also is there a way to have the sheet pull the dates vs. me changing them manually weekly.

Thank you for your help in advance.