Table Formula Sorting Issue

Hi!

I have a table with 4 columns. Columns A and D are just comprised of text, but columns B contains a SUMIF formula [SUMIF('Backup Data'!$E:$E, Legend!A2, 'Backup Data'!$F:$F)] that is referencing another tab called BackUp Data, and column C is a COUNTIF formula [COUNTIF('Backup Data'!$E:$E, Legend!$A2)] referencing the same backup data. I've found that if I sort this table, the B and C columns will not automatically restore calculated column formula. I have the calculation options set to automatic, but it won't work. Every time I am forced to selecte the help button and manually select the "Restore Calculated Column Formula" selection in the first cell of each column, and then pull down to the remaining cells of each column.

Is there a formula or setting that I'm missing on this? It seems like a very simple problem but I can't figure out how to fix it.