In my sheet, I have an F column containing multiple code numbers in each cell.
I want to count the frequency of the codes based on the codes in H
I have framed an array formula like this =SUM(IF(F2:F840=H2,1,0))
See screenshot
Frequency Count.png
But it is returning zero.
Can anyone help by revising the formula?
Bookmarks