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
|