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.