subtotal function

[Debby Bunce]

To all experts,

Please could you help me

i have a list of people( more than 1 entry for the same person) in column a
and and a number in column b

i can get excel to do the subtotal function

i need to copy the subtotaled data to another part of my spreadsheet but one
thing is annoying is that it says

A.SMITH SUBTOTAL 999

how do i remove the word subtotal from the cell but still keeping the
persons name


hope anyone can help



thanks in advance



steve

 

[Dave Peterson]

After you copy and paste

Select that column (columns) and do:
Edit|Replace
what: _subtotal (_ represents a space character)
with: (leave blank)
replace all

 

[Mark Lincoln]

You can use SUMIF:

=SUMIF(A1:A11,"A.SMITH",B1:B11)

This assumes the names are in A1 through A11 (and are always entered in
the same way) and the corresponding numbers are in B1 through B11.

You can put "A.SMITH" in a cell and refer to it in the formula:

=SUMIF(A1:A11,C17,B1:B11)

Where the name you wish to subtotal has been entered in cell C17.

If you want the name and subtotal in the same cell, do this:

="A.SMITH "&SUMIF(A1:A11,"A.SMITH",B1:B11)