Excel Basic function

[Lesotho]

Hi

Know this sounds daft but cant work out how to carry out conditiona
sum of 2 ranges based on the result of a 3rd variable.

i.e. If (Range A = value, then sum (range b * range c)

Any help greatfully appreciate

 

[Domenic]

=SUMPRODUCT(--(A1:A100=NumericalValue),B1:B100*C1:C100)

OR

=SUMPRODUCT(--(A1:A100="TextValue"),B1:B100*C1:C100)

Hope this helps!

 

[Jerry W. Lewis]

=SUMPRODUCT((Range A = value)*(range b * range c))

Jerry