Countif help needed

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

Jess
 
B

Bernie Deitrick

Jessica,

Close:

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


HTH,
Bernie
MS Excel MVP
 
T

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

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

RonaldoOneNil

Use this and adjust the range accordingly

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top