Forum Discussion
Counting single occurrences of a number in a range
This seemed so easy when I first looked this up, using sum len substitute etc. But as try as I might is imply cannot get it to work. I am using 365 for MAC which just maybe the issue, but the request...
Hello chrisrcox,
As a variant:
=SUM(LEN($A$2:$C$11)-LEN(SUBSTITUTE($A$2:$C$11,$E2,"")))/LEN($E2)
This is an array formula so press Ctrl + Shift + Enter
See attached file.
Good work. 365 will calculate it without the CSE.
