Creating a Running Count

[Guest]

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.

 

[Guest]

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