SumProduct Assistance Please

[Guest]

I am trying to sum 2 columns together and multiple it by another cell if one
criteria is met.

The formula I am using is not working and displays #value. It is
=SUMPRODUCT(--(A12:A149=A4),C12:C149+H12:H149)*D2

Data looks like this
A1=Blue
D2=4.5%

Column C and H contain sales dollars

So if A12:A149 = Blue
Then sum the Columns C12:C149 and H12:149
and multiply the Total of Columns C & H by the 4.5 % in cell D2

TIA for your assistance.

This forums has assisted me with many formulas to date, but can't seem to
find one that helps with this.

 

[Guest]

Try:

=SUMPRODUCT(--(A12:A149=A4),(C12:C149+H12:H149))*D2

 

[Bob Phillips]

Why not just use

=(SUMIF(A12:A149,A4,C12:C149)+SUMIF(A12:A149,A4,H12:H149))*D2


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

This worked like a charm.

Thank you for clearing the fog in my head.

 

[Guest]

That did not work, but Bob's reply below did.
Thanks for your assistance