| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count entries within a row
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? |
|
#2
|
|||
|
|||
|
=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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count data but avoid double entries | Excel Worksheet Functions | |||
| How to count matching text | Excel Discussion (Misc queries) | |||
| Count occurences between dates | Excel Worksheet Functions | |||
| Count data entries and date problem | Excel Worksheet Functions | |||
| get count of row without duplicate entries | Excel Worksheet Functions | |||
Linear Mode
