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 -