SUMPRODUCT

[MIK]

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.

 

[Gary''s Student]

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

assuming that A1 is already a percentage

 

[Sheeloo]

=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

 

[Shane Devenshire]

Hi,

Try:

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