Excel Cleaning
 

I am using an old dos based program , and exporting data into Excel. Using
Autofilter I am cleaning the rows that I don't need. However I need to add
(Values) for several sub-categories (sub-total). e.g.. I have five lines with
B02A, B02B, B02C, B02D, B02E.. How do I sum these rows. Other Sub-groups will
have similar descriptions with increasing numbers and different line numbers.
Any help would be greatly appreciated.

Excel Cleaning
 

You need to have a header row, and you should sort your data by those
sub-categories. Then with your cursor somewhere in the table, click on
Data | Subtotals. Work through the dialogue box to set things how you
want them and click OK.

Hope this helps.

Pete

On Nov 5, 7:11 pm, RMT wrote:
I am using an old dos based program , and exporting data into Excel. Using
Autofilter I am cleaning the rows that I don't need. However I need to add
(Values) for several sub-categories (sub-total). e.g.. I have five lines with
B02A, B02B, B02C, B02D, B02E.. How do I sum these rows. Other Sub-groups will
have similar descriptions with increasing numbers and different line numbers.
Any help would be greatly appreciated.

Excel Cleaning
 

One way would be to use Custom BeginsWith BO2 on the AutoFilter, and then
use the SUTOTAL function to get your total.......

Vaya con Dios,
Chuck, CABGx3



"RMT" wrote:

I am using an old dos based program , and exporting data into Excel. Using
Autofilter I am cleaning the rows that I don't need. However I need to add
(Values) for several sub-categories (sub-total). e.g.. I have five lines with
B02A, B02B, B02C, B02D, B02E.. How do I sum these rows. Other Sub-groups will
have similar descriptions with increasing numbers and different line numbers.
Any help would be greatly appreciated.

Excel Cleaning
 

Thanks Pete -
Following your instruction, it is subtotaling each line item. I want to sum
multiple rows in each sub-categoris. Each sub has lines B02A through some
other letter.
Any help.
Thanks
RT

"Pete_UK" wrote:

You need to have a header row, and you should sort your data by those
sub-categories. Then with your cursor somewhere in the table, click on
Data | Subtotals. Work through the dialogue box to set things how you
want them and click OK.

Hope this helps.

Pete

On Nov 5, 7:11 pm, RMT wrote:
I am using an old dos based program , and exporting data into Excel. Using
Autofilter I am cleaning the rows that I don't need. However I need to add
(Values) for several sub-categories (sub-total). e.g.. I have five lines with
B02A, B02B, B02C, B02D, B02E.. How do I sum these rows. Other Sub-groups will
have similar descriptions with increasing numbers and different line numbers.
Any help would be greatly appreciated.

Excel Cleaning
 

You can introduce helper columns with formulae like:

=LEFT(A2,3)

to extract the first 3 letters of what is in column A, then you could
use this column in the "For each change in ..." dialogue to get a
subtotal for B02 followed by any letter.

You can also use the + symbols on the left to reduce/expand the groups
identified by the sub-total routine.

Hope this helps.

Pete

On Nov 6, 5:12 pm, RMT wrote:
Thanks Pete -
Following your instruction, it is subtotaling each line item. I want to sum
multiple rows in each sub-categoris. Each sub has lines B02A through some
other letter.
Any help.
Thanks
RT



"Pete_UK" wrote:
You need to have a header row, and you should sort your data by those
sub-categories. Then with your cursor somewhere in the table, click on
Data | Subtotals. Work through the dialogue box to set things how you
want them and click OK.

Hope this helps.

Pete

On Nov 5, 7:11 pm, RMT wrote:
I am using an old dos based program , and exporting data into Excel. Using
Autofilter I am cleaning the rows that I don't need. However I need to add
(Values) for several sub-categories (sub-total). e.g.. I have five lines with
B02A, B02B, B02C, B02D, B02E.. How do I sum these rows. Other Sub-groups will
have similar descriptions with increasing numbers and different line numbers.
Any help would be greatly appreciated.- Hide quoted text -

- Show quoted text -