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!