Counting occurances and multiplying by a quantity


G

Guest

I would like to create a summary page for a fundraising database I have. I
would like to count the number of times a product number occurs in the
product # but have it add the quantity column for the corresponding row.
Then I want to display the value (the total number of that particular product
ordered) in a separate summary page.

Data Sheet:
Name Phone Product #
Quantity
Example Person 555-555-5555 11111 2
44444 1
55555
3
Example Person 2 222-222-2222 44444 3
55555
2

Summary Sheet:
Product # Quantity
11111 2
44444 4
55555 5

What formula can I use in the quantity column of my summary sheet? If I
listed each product order separately, I could use COUNTIF. Is there a way
for me to count the quantities if a value is true over a range of cells?

Thank you!
 
Ad

Advertisements

B

Bob Phillips

Use SUMIF

=SUMIF(rng1,"11111",rng2)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 

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

Top