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

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

Try something like this...

=SUMPRODUCT(--(A1:A10="car"),--(N1:N10499))

Note that with SUMPRODUCT you *can't* use entire columns as range references
unless you're using Excel 2007.

--
Biff
Microsoft 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

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



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

--

Dave Peterson

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

Thank you so much...enjoy your day!
Jess
--
--------
Jessica Krall
Virginia USA


"T. Valko" wrote:

Try something like this...

=SUMPRODUCT(--(A1:A10="car"),--(N1:N10499))

Note that with SUMPRODUCT you *can't* use entire columns as range references
unless you're using Excel 2007.

--
Biff
Microsoft 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


.

You're welcome!

--
Biff
Microsoft Excel MVP


"Jessica Krall" wrote in message
...
Thank you so much...enjoy your day!
Jess
--
--------
Jessica Krall
Virginia USA


"T. Valko" wrote:

Try something like this...

=SUMPRODUCT(--(A1:A10="car"),--(N1:N10499))

Note that with SUMPRODUCT you *can't* use entire columns as range
references
unless you're using Excel 2007.

--
Biff
Microsoft 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


.