Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUBTOTAL - TJ | Excel Worksheet Functions | |||
subtotal a range of cells on a different worksheet | Excel Worksheet Functions | |||
Printing Multiple sheets on ONE? | Excel Discussion (Misc queries) | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |