Counting occurances and multiplying by a quantity

[vahagberg]

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!

 

[Bob Phillips]

Use SUMIF

=SUMIF(rng1,"11111",rng2)

--

HTH

Bob Phillips

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