Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |