If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Countif help needed
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 |
#2
|
|||
|
|||
Countif help needed
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 |
#3
|
|||
|
|||
Countif help needed
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 |
#4
|
|||
|
|||
Countif help needed
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 |
#5
|
|||
|
|||
Countif help needed
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 |
#6
|
|||
|
|||
Countif help needed
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 . |
#7
|
|||
|
|||
Countif help needed
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 . |
Thread Tools | |
Display Modes | |
|
|