View Single Post
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

=COUNTIF(Range,""&X2)

where X2 houses a criterion value like 90.

thewiz wrote:
I have numbers within a row that signify grades. Example: 10 rows with
individual numbers 0 thru 100. I would like to count the number of time 90
shows up, then the number of times 80 shows up, then the number of time 70
shows up etc. Is there a formula that will count these numbers?