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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a Running Count
It sounds like you want to use the SUMIF function.
=SUMIF(Range,Criteria,SumRange) LEt's say you are starting in Row 1 =SUMIF(A$1:A1,A1,B$1:B1) Copy down as needed. HTH, Barb Reinhardt "BG" wrote: 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. |
Reply |
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 |