Try this:

=SUMPRODUCT(--(A2:A5="new york"),--(B2:B5="ford"))

Hope this helps.

Pete

On Apr 19, 5:13*pm, embee wrote:
I need a formula similar to the countifs function offered in excel 2007. *I'm
using excel 2003 and can't upgrade to 2007. *I want to add together cars at a
particular location. *The location names are in one column and the type of
car is in another. *In 2007, the formula would be =countifs(a2:a5,"new york",
b2:b5,"ford"). *What can I do to perform the same function in 2003? *Please
help.