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.