Frequency Formula too Slow

[geng]

I have a frequency formula below, but it's too slow to calculate, and sometimes it just freezes.

Is there another way to make it faster?

Or do I have to create a VBA instead? and will VBA make it faster?


=SUM(IF(FREQUENCY(IF('RAW DATA'!F:F=D4,MATCH('RAW DATA'!B:B,'RAW DATA'!B:B,0)),ROW('RAW DATA'!B:B)-ROW('RAW DATA'!B$3)+1),1))

Thanks!!!