Subtotal without "xxxx total" but only xxxx

[ashish128]

Hello to everyone, i have a .xls file as
A B
4 5
4 6
4 8
6 6
6 1
6 2
6 5
6 9
11 1
11 6
11 5
11 7
12 4
12 6

I need to subtotal column B based on Column A but I dont want "4
Total", "6 Total" or "11 Total"
What I require is
4 19
6 23
11 19
12 10

Is there any way to do this
Please help

 

[Bondi]

Hi,

I'mnot sure if this is what you are looking for but this will give you
19 for 4

=SUMIF(A1:A14,"=4",B1:B14)

Regards,

Bondi

 

[JimMay]

Or if your A1 is 11 Total then use in B1 =LEFT(A1,LEN(A1)-6)
Just a thought..

 

[Dave Peterson]

How about doing your Data|subtotal

The select that column and
edit|Replace
what: _total (include the leading space character)
with: (Leave blank)
replace all