Chip has given you a full answer but you might also need to know that XL2007
allows full column references in array formulas. So in XL2007 I can use
=SUMPRODUCT(--(A:A="Apple"),
--(B:B="Granny Smith"), C:C)
This will not work in earlier versions
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"confused!!" wrote in message
...
are formuals in 2007 compatible with 2003 with the exception of saving the
worksheet as compatible with 2003