software

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 quot;4
Totalquot;, quot;6 Totalquot; or quot;11 Totalquot;
What I require is
4 19
6 23
11 19
12 10

Is there any way to do this
Please helpHi,

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

=SUMIF(A1:A14,quot;=4quot;,B1:B14)

Regards,

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

quot;ashish128quot; gt; wrote in message oups.com:

gt; Hello to everyone, i have a .xls file as
gt; A B
gt; 4 5
gt; 4 6
gt; 4 8
gt; 6 6
gt; 6 1
gt; 6 2
gt; 6 5
gt; 6 9
gt; 11 1
gt; 11 6
gt; 11 5
gt; 11 7
gt; 12 4
gt; 12 6
gt;
gt; I need to subtotal column B based on Column A but I dont want quot;4
gt; Totalquot;, quot;6 Totalquot; or quot;11 Totalquot;
gt; What I require is
gt; 4 19
gt; 6 23
gt; 11 19
gt; 12 10
gt;
gt; Is there any way to do this
gt; Please helpHow 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:
gt;
gt; Hello to everyone, i have a .xls file as
gt; A B
gt; 4 5
gt; 4 6
gt; 4 8
gt; 6 6
gt; 6 1
gt; 6 2
gt; 6 5
gt; 6 9
gt; 11 1
gt; 11 6
gt; 11 5
gt; 11 7
gt; 12 4
gt; 12 6
gt;
gt; I need to subtotal column B based on Column A but I dont want quot;4
gt; Totalquot;, quot;6 Totalquot; or quot;11 Totalquot;
gt; What I require is
gt; 4 19
gt; 6 23
gt; 11 19
gt; 12 10
gt;
gt; Is there any way to do this
gt; Please help

--

Dave Peterson