Frequency syntax

[The Grim Discovery]

Hello

Recently I got some help on here putting a frequency function into a worksheet. I've been using & adapting this as required.

This is typical of the formula I've been using.

{=SUM(--(FREQUENCY(IF($V$4:$V$498="UNITED 1",MATCH($AD$4:$AD$498,Nov2018Daily!$AD$4:$AD$498,0)), ROW($AD$4:$AD$498)-ROW(AD35)+1)>0))}

But in the instance above I need to match both "United 1" and "United 2" into the same formula - that is I want the frequency of "United 1" and "United 2" to be aggregated as one. So if there are 5 instances of "United 1" and 3 instances of "United 2" I'd want the answer to be generated as 8

I've been summing and sum-producting this formula with no luck. Can this be done? Can you show how?
Thanks in advance.

 

[Domenic]

Try the following formula, which also needs to be confirmed with CONTROL+SHIFT+ENTER...

=SUM(--(FREQUENCY(IF(ISNUMBER(MATCH($V$4:$V$498,{"UNITED 1","UNITED 2"},0)),MATCH($AD$4:$AD$498,$AD$4:$AD$498,0)), ROW($AD$4:$AD$498)-ROW($AD$4)+1)>0))

Note that I assumed that all referenced ranges are located on the same sheet, so I removed the sheet reference to Nov2018Daily. Add the sheet reference to your ranges, if necessary. Also, I replaced ROW(AD35) with what I believe should be ROW($AD$4).

Hope this helps!

 

[The Grim Discovery]

It does indeed help Domenic - thanks again