Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Subtotals
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Subtotals
How about putting another column in your data:
=a2&","b2" and drag down. Then sort by this column and apply Data|subtotals using that column as the key. bob wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Subtotals
Hi,
Try the following array formula (Ctrl+shift+Enter) =sum(if((rangeA="Sievers")*(rangeB="Marks"),rangeC )) You may copy this range to column D and E now. If you have any further questions, please feel free to contact me at Regards, Ashish "bob" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |