Countif help needed

  • Thread starter Thread starter Jessica Krall
  • Start date Start date
J

Jessica Krall

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
Click to expand...
=SUM((District="CAR")*(Days>499)) as an array, but neither works...help
please!!

Jess
 
Jessica,

Close:

=SUMPRODUCT((District="CAR")*(Days>499))


HTH,
Bernie
MS Excel MVP
 
Try something like this...

=SUMPRODUCT(--(A1:A10="car"),--(N1:N10>499))

Note that with SUMPRODUCT you *can't* use entire columns as range references
unless you're using Excel 2007.
 
And if you're using xl2007, take a look at =countifs() in Excel's help.

And if District and Days are names of entirecolumns, then Biff explained why it
failed in xl2003 (and below).
 
Use this and adjust the range accordingly

=SUMPRODUCT((A1:A1000="CAR")*(N1:N1000>499))
 
Back
Top