Countif - extended functionality
If these are typed into a single cell then they will be treated as
text values, not numbers. You could use FIND or SEARCH to look for
"17" in each cell, but of course this will also find "173" and "317".
Hope this helps.
Pete
On May 14, 11:14*am, Mac wrote:
Hello,
having a column in which data is entered like (1 line here denoted 1 cell)
1,14,17
2
3,8
12,14
14,14,17
the usual countif won't work, of course. How do I go about a formula such as
- "give me a count of all occurrences of the number 17 in the given range"?
|