Sum of like items

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=SUMIF(A:A,"item1",B:B)

where items would be in A and their numbers in B

--
Regards,

Peo Sjoblom

Portland, Oregon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing data 6
summing arrays 4
Access Access 2010 report summing 0
extract 1 of each item 3
Sum Multiple Tabs of Data 2
Adding up row values 4
Sum of a invoice- problem with vlookup 2
Sum formular using vlookup 7

Back
Top