I have been using the Sum and Subtotal function on my spreadsheet for a year
with no problem. All of a sudden when I change my formula to include
additional lines or use the filter, the formulas are no longer working. It
autofills correctly, but carries the total from the 1st column all the way
across and does not change when I change the filters unless I click in the
formula bar for each column.