Data Sort Question
 

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

Data Sort Question
 

A SUMIF function would probably be your best option here. How are the
managers identified? I'll assume that the managers are listed in column B
for this example.

=SUMIF(B1:B36,"Manager A",A1:A36)

This looks for "Manager A" in column B, and adds the corresponding value
from column A when it is found. This way, it will not matter how the data is
sorted.

HTH,
Elkar


"bankerlady" wrote:

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

Data Sort Question
 

That worked ! Thanks. I was missing the "qualifier" which I had to go in and
add on column A to denote which manager. thanks again for your help.

"Elkar" wrote:

A SUMIF function would probably be your best option here. How are the
managers identified? I'll assume that the managers are listed in column B
for this example.

=SUMIF(B1:B36,"Manager A",A1:A36)

This looks for "Manager A" in column B, and adds the corresponding value
from column A when it is found. This way, it will not matter how the data is
sorted.

HTH,
Elkar


"bankerlady" wrote:

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