Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting occurances and multiplying by a quantity
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting occurances and multiplying by a quantity
Use SUMIF
=SUMIF(rng1,"11111",rng2) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "vahagberg" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting occurances | Excel Worksheet Functions |