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

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

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?

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

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?

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

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