Excel Cleaning

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Back
Top