| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count based on cell value between two numbers
Perhaps for the more experienced this is easy. I hope so.
I want to build a sheet that scores a point value based on data entered in one cell. I would like to score a point for any number between 1 and 20, two points for any number between 21 and 40, etc... I imagine it's some version of an IF formula but I can't seem to figure it out. Any help would be appreciated. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count based on string in cell | Excel Worksheet Functions | |||
| Auto Count & Format based on cell value | Excel Discussion (Misc queries) | |||
| how to count cell based on 2 Criteria | Excel Discussion (Misc queries) | |||
| COUNT dates in ColumnY based on numbers in ColumnX | Excel Worksheet Functions | |||
| "count if" function based on value of another cell | Excel Worksheet Functions | |||
Threaded Mode
