Need quick excel formula, countif

[mkx]

Hi all, any excel wizards here that can provide me with a formula to do the following?

A B C
Order# Qty Product
333 3 Apple battery
288 1 Banana
489 3 Etc..
093 2
333 1 Orange
280 1
288 1

I want to count the total amount of products sold per order so the result for 333 would be 4 since it sold 3 apple batteries and 1 orange. I would like to display this result in D2

[KRosh]

Hi all, any excel wizards here that can provide me with a formula to do the following?

A B C
Order# Qty Product
333 3 Apple battery
288 1 Banana
489 3 Etc..
093 2
333 1 Orange
280 1
288 1

I want to count the total amount of products sold per order so the result for 333 would be 4 since it sold 3 apple batteries and 1 orange. I would like to display this result in D2

You need to use "vlookup"
Read about it and you can create a quick formula
https://trackpal.com/blog/vlookup-for-beginners/

[BigFurry]

Or create a Pivot Table and group by Order# in there.

https://support.office.com/en-us/art...0-0cf0b9b880f7