Try something like this...

=SUMPRODUCT(--(A1:A10="car"),--(N1:N10499))

Note that with SUMPRODUCT you *can't* use entire columns as range references
unless you're using Excel 2007.

--
Biff
Microsoft Excel MVP


"Jessica Krall" <Jessica wrote in message
...
I am trying to use a countif statement for column A to count the number of
times a District is "CAR" PLUS those CAR listings where column N (DAYS) is
499. I've tried =COUNTIF(A:A="CAR")+(N:N="499") and
=SUM((District="CAR")*(Days499)) as an array, but neither works...help
please!!

Jess