Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Running Count
OK I'm not even sure how to ask this:
I am in the printing industry and I would like to be able to keep a running count on how many of each different type of stock I run. In column A I have the code for a certain stock and in column B i have how many we ran. Column C is the PO number, but thats not important. I am wondering if there is a way to get excel to identify all the rows that contain a certain stock code(column A) and add the number of pages run(column B)? Anyone have an idea of how to do it? If I can drop the info in a different part of the sheet, or on a different sheet, it would prevent me from having to sort and add up all the jobs with the same stock. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Creating running clocks in multiple cells. | Excel Worksheet Functions | |||
creating a running average | New Users to Excel | |||
Creating a vehicle running sheet?? | Excel Programming | |||
creating a running tally | Excel Programming |