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.