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 to count more than one item?
All,
Can Countif function count more than one criteria? I.e I have a column and want to count all but one of the criteria in that column. Column has MD, LK, Fac and No in it, I want to count all but No. Is this possible with the countif function? -- Adam ----------- Windows 98 + Office Pro 97 |
#2
|
|||
|
|||
Countif to count more than one item?
Hi Adam,
Can Countif function count more than one criteria? I.e I have a column and want to count all but one of the criteria in that column. Column has MD, LK, Fac and No in it, I want to count all but No. Lets say this is column A, then try this array formula. =SUM(IF(OR(A1:A100="MD",A1:A100="LK",A1:A100="Fac" ),1,0)) Enter the formula by hitting control-shift-enter. Excel will add {} around the formula. Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#3
|
|||
|
|||
Countif to count more than one item?
How about
=COUNTIF(rng, "No") In article , "Adam" wrote: All, Can Countif function count more than one criteria? I.e I have a column and want to count all but one of the criteria in that column. Column has MD, LK, Fac and No in it, I want to count all but No. Is this possible with the countif function? |
#4
|
|||
|
|||
Countif to count more than one item?
Adam
Try: =COUNTIF(A2:A1000,"No") To count all Fac's and No's, try =SUMPRODUCT((A2:A1000="Fac")*(A2:A1000="No")) -- Best Regards Leo Heuser Followup to newsgroup only please. "Adam" skrev i en meddelelse ... All, Can Countif function count more than one criteria? I.e I have a column and want to count all but one of the criteria in that column. Column has MD, LK, Fac and No in it, I want to count all but No. Is this possible with the countif function? -- Adam ----------- Windows 98 + Office Pro 97 |
#5
|
|||
|
|||
Countif to count more than one item?
If you need to exclude blanks, try:
=SUMPRODUCT(--(rng"No"),--(rng"")) In article , "Adam" wrote: All, Can Countif function count more than one criteria? I.e I have a column and want to count all but one of the criteria in that column. Column has MD, LK, Fac and No in it, I want to count all but No. Is this possible with the countif function? |
#6
|
|||
|
|||
Countif to count more than one item?
Hi
Try =COUNTIF(A2:A1000,"No") -- Andy. "Adam" wrote in message ... All, Can Countif function count more than one criteria? I.e I have a column and want to count all but one of the criteria in that column. Column has MD, LK, Fac and No in it, I want to count all but No. Is this possible with the countif function? -- Adam ----------- Windows 98 + Office Pro 97 |
#7
|
|||
|
|||
Countif to count more than one item?
Leo Heuser wrote:
. . . To count all Fac's and No's, try =SUMPRODUCT((A2:A1000="Fac")*(A2:A1000="No")) Or =SUM(COUNTIF(A1:A1000,{"Fac","No"})) Alan Beban |
Thread Tools | |
Display Modes | |
|
|