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.
--
Excel Noobie