Is there anyway to countif for multiple things?

like = countif(Range, "1" or "2")

I know you can do "<1" dor does not equal but can you do combos within a
countif or do you have to run multiple countifs

Thanks
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!

Hi there Blue,

Yes, there is. You can either use two COUNTIF() functions...

=COUNTIF(A2:A10,"=1")+COUNTIF(A2:A10,"=2")

Or you can use a slight workaround for using only one function...

=SUMPRODUCT((A2:A10=1)+(A2:A10=2))

Change the range(s) to suit. Note if you are using the SUMPRODUCT()
function the ranges must be exactly the same in dimensions. The COUNTIF()
should work faster though.

HTH

--
Zack Barresse



"BlueWolverine" wrote in message
...
Is there anyway to countif for multiple things?

like = countif(Range, "1" or "2")

I know you can do "<1" dor does not equal but can you do combos within a
countif or do you have to run multiple countifs

Thanks
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!

Try this:

=SUM(COUNTIF(Range,{"1","2"}))


"BlueWolverine" wrote:

Is there anyway to countif for multiple things?

like = countif(Range, "1" or "2")

I know you can do "<1" dor does not equal but can you do combos within a
countif or do you have to run multiple countifs

Thanks
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!

Thank you! I Particularly like the sum(countif({})) method!

--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!


"Teethless mama" wrote:

Try this:

=SUM(COUNTIF(Range,{"1","2"}))


"BlueWolverine" wrote:

Is there anyway to countif for multiple things?

like = countif(Range, "1" or "2")

I know you can do "<1" dor does not equal but can you do combos within a
countif or do you have to run multiple countifs

Thanks
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!

Is there a way to do the same thing with a cell?

=SUM(COUNTIF(023:Q23, 024 or P24)

I've tried and it returns a "0".

Thanks, Terry


On Apr 28, 1:12*pm, BlueWolverine
wrote:
Thank you! I Particularly like thesum(countif({})) method!

--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!



"Teethless mama" wrote:
Try this:

=SUM(COUNTIF(Range,{"1","2"}))

"BlueWolverine" wrote:

Is there anyway tocountiffor multiple things? *

like =countif(Range, "1" or "2")

I know you can do "<1" dor does not equal but can you do combos within a
countifor do you have to run multiple countifs

Thanks
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!- Hide quoted text -

- Show quoted text -

=COUNTIF(O23:Q23,O24)+COUNTIF(O23:Q23,P24)

--
Zack Barresse




"Tmaxx02" wrote in message
...
Is there a way to do the same thing with a cell?

=SUM(COUNTIF(023:Q23, 024 or P24)

I've tried and it returns a "0".

Thanks, Terry


On Apr 28, 1:12 pm, BlueWolverine
wrote:
Thank you! I Particularly like thesum(countif({})) method!

--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!



"Teethless mama" wrote:
Try this:

=SUM(COUNTIF(Range,{"1","2"}))

"BlueWolverine" wrote:

Is there anyway tocountiffor multiple things?

like =countif(Range, "1" or "2")

I know you can do "<1" dor does not equal but can you do combos
within a
countifor do you have to run multiple countifs

Thanks
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!- Hide quoted text -

- Show quoted text -

Or..

=COUNT(IF((O23:Q23=O24)+(O23:Q23=P24),O23:Q23))

Confirmed with Ctrl + Shfit + Enter

--
Zack Barresse



"Tmaxx02" wrote in message
...
Is there a way to do the same thing with a cell?

=SUM(COUNTIF(023:Q23, 024 or P24)

I've tried and it returns a "0".

Thanks, Terry


On Apr 28, 1:12 pm, BlueWolverine
wrote:
Thank you! I Particularly like thesum(countif({})) method!

--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!



"Teethless mama" wrote:
Try this:

=SUM(COUNTIF(Range,{"1","2"}))

"BlueWolverine" wrote:

Is there anyway tocountiffor multiple things?

like =countif(Range, "1" or "2")

I know you can do "<1" dor does not equal but can you do combos
within a
countifor do you have to run multiple countifs

Thanks
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!- Hide quoted text -

- Show quoted text -