Calculating Duplicate Cells

R

RicoHoward

I have a worksheet that I am working on to purchase equipment. I have
multiple duplicate items to be ordered that are seperated by departments. I
want to be able to calculate the duplicate items so that I will see how many
ordered per that that particular item no matter which group they come from
....basically a total for that particular item ordered not a breakdown
 
T

Toppers

=SUMIF(A1:A100,"item #",B1:B100)

where column A is item number
column B is quantity ordered
"item #" is the item number

Or I have misunderstood?
 
Top