Not very sophisticated but it works
=(ABS(C41)<=1)+(ABS(C61)<=1)+(ABS(C81)<=1)+(ABS(C1 01)<=1).....
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"dakotablu" wrote in message
...
I am trying to count random cells (non contiguous) in the same column and
show (in one cell) the total number that are 1, =0, <1

my formula thus far =COUNT(C41,C61,C81,C101,C121,C141,C161,C181)
this shows how many numbers (8)

How do I distinguish for my criteria above?

Your thoughts are appreciated.