I have a spreadsheet with 36 lines of data and four columns, each column has
a total.

Two lines below that total I want to add some new totals, i.e., I want to
add a total for a specific manager. Example: manager A is responsible for
the offices with totals listed in A12, A14, A20, A22 and A25.

I have no problems creating that sum, but when I go back and data sort the
sheet to reflect production in descending order it of course changes my
totals for manager A because it redistributes the data in those specific
cells. Is there a way to "freeze" the total for manager A and just sort the
sheet above ? I am not including the manager data at the bottom in any of the
sorting, it automatically changes.

I could copy and paste it with past special values and that would work on
the short run if I just had one sheet and one month to work with, but I have
25 separate reports and six managers and it will be ongoing from now on, so
I've got to find a better way to make it work.

I've tried SUMIF and that didn't work, so any suggestions appreciated !!
Thanks