Excel Basic function

L

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
 
D

Domenic

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

OR

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

Hope this helps!
 
Top