Adding rows of data based on first column

  • Thread starter Thread starter Dewaynep
  • Start date Start date
D

Dewaynep

Not sure if I worded that correctly. Here's what I need to do: I have sales
data for a month that is listed individually by date and item number. I need
to go through the entire workbook and find each occurance of each item and
add together the number of items ordered. Here is an example:
Item TotalOrdered
119 1
121 1
121 1
121 1
182 1
182 1
206 1
206 1
223 1
589 1
589 1
As you can see, item 121 had 3 ordered, 589 had 2 ordered. Is there a
formula I can use to do this automatically? Thanks.
 
Thanks Don. I checked Countif, and it looks like would work if "total
ordered" was always 1, but that is not the case. I have to be able to look up
the item number and add the number(s) in column "b" together. Would I still
use countif?
 
Your OP said COUNT. If you want to count use countif. If you want to
"add the number(s) in column "b" together" use
=SUMIF(H2:H22,589,I2:I22)
 
Back
Top