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...
Try this:
=SUM(IF(MID($A$1:$A$25,{1,2},1)=TEXT(D2,"0"),1,0))+SUM(IF(MID($B$1:$B$25,{1,2},1)=TEXT(D2,"0"),1,0))
Workbook attached.