SUMIF and conditional Question
SUMIF and conditional Question
(OP)
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
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





RE: SUMIF and conditional Question
TTFN
RE: SUMIF and conditional Question
Thank you very much for the tip about the Pivot Table. I have not thought about it before.
It did solve my problem.
Thanks
RE: SUMIF and conditional Question
{=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