Subtotal without "xxxx total" but only xxxx
 

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

Subtotal without "xxxx total" but only xxxx
 

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

Subtotal without "xxxx total" but only xxxx
 

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

"ashish128" wrote in message
oups.com:

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

Subtotal without "xxxx total" but only xxxx
 

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



ashish128 wrote:

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

--

Dave Peterson