Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping running tallies of items in two columns
I need to keep separate running numerical tallies for products. The products
are listed in column C, and their quantities are listed in column B. Column C can contain various products, listed multiple times. For example: Column B Column C 1 Product A 4 Product C 2 Product B 5 Product C 3 Product A The running totals for each product a Product A = 4 Product B = 2 Product C = 9 I could do this myself with some simple in-cell If/Then statements, except that the total number of unique products I am working with is 117. Furthermore, the size (number of rows) of the list fluctuates. So I am looking for a macro that will look at the values in column C and tally the quantities in column B. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping running tallies of items in two columns
Hi
No macro needed, just this little formula. With headings in row 1, set up a unique list of your products in column F and put this formula in G2 and copy it down: =SUMPRODUCT($B$2:$B$1000,--($C$2:$C$1000=F2)) Best regards, Per On 16 Jan., 23:26, brettopp wrote: I need to keep separate running numerical tallies for products. *The products are listed in column C, and their quantities are listed in column B. *Column C can contain various products, listed multiple times. *For example: Column B * *Column C * * * * 1 * * * *Product A * * * * 4 * * * *Product C * * * * 2 * * * *Product B * * * * 5 * * * *Product C * * * * 3 * * * *Product A The running totals for each product a Product A = 4 Product B = 2 Product C = 9 I could do this myself with some simple in-cell If/Then statements, except that the total number of unique products I am working with is 117. * Furthermore, the size (number of rows) of the list fluctuates. *So I am looking for a macro that will look at the values in column C and tally the quantities in column B. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping running tallies of items in two columns
Thank you, Jessen. I believe this will work. Much appreciated.
"Per Jessen" wrote: Hi No macro needed, just this little formula. With headings in row 1, set up a unique list of your products in column F and put this formula in G2 and copy it down: =SUMPRODUCT($B$2:$B$1000,--($C$2:$C$1000=F2)) Best regards, Per On 16 Jan., 23:26, brettopp wrote: I need to keep separate running numerical tallies for products. The products are listed in column C, and their quantities are listed in column B. Column C can contain various products, listed multiple times. For example: Column B Column C 1 Product A 4 Product C 2 Product B 5 Product C 3 Product A The running totals for each product a Product A = 4 Product B = 2 Product C = 9 I could do this myself with some simple in-cell If/Then statements, except that the total number of unique products I am working with is 117. Furthermore, the size (number of rows) of the list fluctuates. So I am looking for a macro that will look at the values in column C and tally the quantities in column B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keeping a running list | Excel Discussion (Misc queries) | |||
Keeping a running time total | Excel Programming | |||
keeping a running time for tv program | Excel Worksheet Functions | |||
Keeping formulas on running total and sorts | Excel Worksheet Functions | |||
Keeping running totals | New Users to Excel |