Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have five columns of data. Columns 1 and 2 are populated with names,
columns 3 through 5 with numbers. I would like to automatically create subtotals in column in columns 3 through 5 for each combination of names that appear on the same row in columns A and B. Example: Allen Barringer 4 16 30 Boldin Howard 6 8 4 Sievers Marks 7 10 54 Allen Marks 4 55 12 Howard Billens 44 5 66 Boldin Marks 33 55 1 Sievers Marks 5 12 40 Sievers Marks 0 22 33 Howard Billens 1 18 22 I would like to subtotal columns 3-5 each time Sievers and Marks appear on the same row in columns A and B, respectively. Thanks for your help, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Have you had a problem with Auto Filter freezing? | Excel Discussion (Misc queries) | |||
auto filter question | Excel Worksheet Functions | |||
auto filter question | Excel Worksheet Functions | |||
The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |