View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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