I have a rather large workbook and have been using a SUMIFFS formula that is starting to become a little cumbersome and i need to modify to alleviate constant corrections.

My example I posted has 3 sheets.

sheet "TEST1" has a pivot table of data pulled from my server. The problem is some lines will be removed over time.

Sheet "TEST2" and "TEST3" Has data pulled from TEST1

The problem i am having is I have written the formula to look in a specific row and Cell so when a row is deleted I have to modify to formula to look in the correct cell. The funny part is probably has worked for several years until recently but i do realize there is a better way just not found it yet.

my formula is below:

=SUMIFS(Test1!C8,Test1!A8,$AJ$7,Test1!B8,"G") I tried to keep make sure i referenced the specific item in AJ7.

I think i should transition this formula to probably a Vlookup but open to any suggestions