Forum Discussion
chrisrcox
Feb 24, 2020Copper Contributor
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...
Twifoo
Feb 26, 2020Silver Contributor
Given your specified parameters, this non-array formula returns your desired results:
I prefer SUMPRODUCT instead of SUM, which also returns the same results if confirmed with Ctrl+Shift+Enter.