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.

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.

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.

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 -

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.