Thread: count them number of cells between values -2 and 2 including 0
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default count them number of cells between values -2 and 2 including 0
Hi!

Try one of these:

=COUNTIF(A1:A10,"=-2")-COUNTIF(A1:A10,"2")

=SUMPRODUCT(--(ISNUMBER(A1:A10)),--(A1:A10=-2),--(A1:A10<=2))

Biff

"Helppppppppppppppppppppppppppppp"
osoft.com wrote in
message ...
I have a list of data I would like to count the number of cells that have
the
following data -2, -1, 0, 1, 2.




Reply With QuoteReply With Quote