Countif - extended functionality
On May 14, 3:14 pm, 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"?
=COUNTIF(A:A,"*17*")
|