No, but you can use multiple criteria with SUMPRODUCT.
Example =SUMPRODUCT(--(A1:A100="Jack"),--(B1:B100="Car"),C1:C100=5, D1:D100)
will sum d1:d100 cells provides corresponding A cell has Jack, B cell has
Cars and C cells equals 5

See also http://contextures.com/xlFunctions01.html#SumProduct

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Patricia" wrote in message
...
Would appreciate knowing if anyone knows how to do this, and if so what is
the syntax. Thanks.