sumproduct

doggies · Apr 28, 2004

hi, is there any way to sumproduct if col A is "c" so that answe
returns 28? tks

A B C
c 2 4
h 3 4
c 4

Leo Heuser · Apr 28, 2004

doggies

One way:

=SUMPRODUCT((A2:A4="c")*B2:B4*C2:C4)

Frank Kabel · Apr 28, 2004

Hi
try
=SUMPRODUCT(--(A1:A100="c"),B1:B100,C1:C100)