Use this and adjust the range accordingly

=SUMPRODUCT((A1:A1000="CAR")*(N1:N1000499))

"Jessica Krall" wrote:

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