Thread: count them number of cells between values -2 and 2 including 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default count them number of cells between values -2 and 2 including 0
=SUMPRODUCT(--(A1:A10=-2),--(A1:A10<=2)) will give total number of cells
with value between -2 to +2

For individual counts:

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

HTH

"Helppppppppppppppppppppppppppppp" wrote:

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