Sum of like items
 

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

Sum of like items
 

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

where items would be in A and their numbers in B

--
Regards,

Peo Sjoblom

Portland, Oregon




"JCowell" wrote in message
...
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