SumProduct Assistance Please
 

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.

SumProduct Assistance Please
 

Try:

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

"ladara tech" wrote:

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.

SumProduct Assistance Please
 

Why not just use

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


--
HTH

Bob

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

"ladara tech" wrote in message
...
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.

SumProduct Assistance Please
 

This worked like a charm.

Thank you for clearing the fog in my head.


"Bob Phillips" wrote:

Why not just use

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


--
HTH

Bob

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

"ladara tech" wrote in message
...
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.

SumProduct Assistance Please
 

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

"Toppers" wrote:

Try:

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

"ladara tech" wrote:

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.