Yes there is. Just trying entering this data

A1:A10 (RangeA): Name,Bill,Bill,Bill,Joe,Joe,Joe,Mark,Jim,Jack
B1:B10 (RangeB): Year,2008,2009,2008,2007,2008,2009,2007,2007,2007
C1:C10 (SumRange): Amt,1,2,3,4,5,6,7,8,9

Run this formula,

=SUMPRODUCT(--(RangeA="Bill"),--(RangeB=2008),SumRange)

and you get 4 as you would expect. But try

=SUMPRODUCT((RangeA="Bill")*(RangeB=2008)*(SumRang e))

and see wat you get.

I get 4 for both formulas.

Rick