Countif help needed

[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

=SUM((District="CAR")*(Days>499)) as an array, but neither works...help
please!!

Jess

 

[Bernie Deitrick]

Jessica,

Close:

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


HTH,
Bernie
MS Excel MVP

 

[T. Valko]

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.

 

[Dave Peterson]

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).

 

[RonaldoOneNil]

Use this and adjust the range accordingly

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

 

[Jessica Krall]

Thank you so much...enjoy your day!
Jess

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you so much...enjoy your day!
Jess