Hi guys,

I have a very cool function that was created with a help here in this forum. Now I need to make on adjustment to it. I need to search fro two options.
I need to search not just C410 in a listed reference column, but also C300. I know there is an OR function for it, just don't know where to put it in.

The function is:

=SUM(IF(FREQUENCY(IF(LEFT('C300-C410'!C16:C2810,4)="C410",MATCH('C300-C410'!C16:C2810,'C300-C410'!C16:C2810,0)),ROW('C300-C410'!C16:C2810)-ROW('C300-C410'!C15)+1),1))

Thanks