Originally Posted by 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