| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 78697 | 2007-04-25 04:41:00 | xl formula | rny (6943) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 544201 | 2007-04-25 04:41:00 | Could anyone help me with a formula to count the number of times a specific numerical value has been reached in an excel spreadsheet. Hope this is enough info without going into a lot of detail. rny |
rny (6943) | ||
| 544202 | 2007-04-25 05:01:00 | =COUNTIF(B4:B16,2) where the range of numbers is b4 - b16 and you want to count how many times 2 appears | wotz (335) | ||
| 544203 | 2007-04-25 10:37:00 | Ta wotz, will try that. Looks like it will do the job. rny |
rny (6943) | ||
| 544204 | 2007-04-27 05:19:00 | Thanks wotz, that was exactly what I wanted. rny |
rny (6943) | ||
| 1 | |||||