SUMPRODUCT
 

HI,

Can someone help me please?
Cell "L21" needs a total of following;
If code "BC" is found in range "B14:B391", find value from "H14:H391" and
then multply with a percentage rate in "A1"

Thank you.

SUMPRODUCT
 

=VLOOKUP("BC",B14:H391,7)*A1

assuming that A1 is already a percentage
--
Gary''s Student - gsnu200839

SUMPRODUCT
 

=SUMPRODUCT(--(B14:B391="BC"),(H14:H391))
will give you the SUM for rows having BC in Col B

Multiply it with A1 to get the percentage like this
=(SUMPRODUCT(--(B14:B391="BC"),(H14:H391)))*A1

Use
=(SUMPRODUCT(--(B14:B391="BC"),(H14:H391)*A14:A391))
If you have percentages in A14:A391 for each row

"MIK" wrote:

HI,

Can someone help me please?
Cell "L21" needs a total of following;
If code "BC" is found in range "B14:B391", find value from "H14:H391" and
then multply with a percentage rate in "A1"

Thank you.

SUMPRODUCT
 

Hi,

Try:

=SUMIF(B14:B391,"BC",H14:H391)*A1

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MIK" wrote:

HI,

Can someone help me please?
Cell "L21" needs a total of following;
If code "BC" is found in range "B14:B391", find value from "H14:H391" and
then multply with a percentage rate in "A1"

Thank you.