SUMIF and conditional Question

[pulga]

Hello Everyone,
Product Volume Customer Type
40194 4,800 Bottom 70
40194 1,000 Bottom 70
40194 42 Bottom 70
40194 0 Bottom 70
40194 8,000 Middle 20
40194 0 Top 10
40196 2,000 Bottom 70
40196 42 Top 10
40233 39 Bottom 70
40233 413 Bottom 70
40233 1 Bottom 70
40233 39 Bottom 70
40233 34 Top 10
40233 8 Top 10

My problem is:
I need to sum the Volume by each Product and by customer type.
For example:
Product # 40194 - Bottom 70 = 5,842
Middle 20 = 8,000
Top 10 = 0
Product # 40196 - Bottom 70 = 2,000
Middle 20 = 0
Top 10 = 42
How can I do this with function on excel?
I do have a list of 5,000 products.

thank you

 

[IRstuff]

Sounds like a perfect application for the Pivot Table.

TTFN

 

[pulga]

Great !!!
Thank you very much for the tip about the Pivot Table. I have not thought about it before.
It did solve my problem.
Thanks

 

[jabaldauf]

Your subject heading is perfect. Use an array function something like this:
{=Sum(If(product=40194,If(customertype=bottom70,volume,0),0))}

Note the {} braces are not typed in, but appear when the formula is entered as an array formula by pressing ctrl-shft-enter.

-JimB