Sum of like items

J

JCowell

I have a usage report I'm dealing with that has multiple lines which
represent the same product but show different quanitities puchased by
different customers on different invoices. I want to sum all of the like
items together to give me a sum of all of a particular item's sold. This is
a large worksheet with hundreds of thousand lines.

Hope you can help-

JCowell
 
P

Peo Sjoblom

=SUMIF(A:A,"item1",B:B)

where items would be in A and their numbers in B

--
Regards,

Peo Sjoblom

Portland, Oregon
 
Top