Jessica,

Close:

=SUMPRODUCT((District="CAR")*(Days499))


HTH,
Bernie
MS 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