got sumproduct to work, though

=SUMPRODUCT(($I$3:$I$18={"G","H","K","M"})*($J$3:$ J$18))

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i was just wondering why this only brings back the value of G, and not the
others.

=SUMIF(I$4:I$18,{"G","H","K","M"},J$4:J$18)

--


Gary