Using an IF statement with the FREQUENCY function

[Scott Fergus]

Hi,
Slight problem in trying to figure out if I can use an IF statement in a FREQUENCY array formula, something along the lines of (and I know this doesn't work ):

{=if(c1:c100>0),frequency(b1:b100,a1:a10)}

I have no idea if this is even possible. Can't find anything online anywhere.

Any guidance is appreciated.
Thanks

 

[yesterdays]

So, you want to calculate the frequency of B1:B100 (which have corresponding C > 0 )in A1:A10 right ?

 

[Scott Fergus]

That's exactly right

 

[yesterdays]

Try this :
=FREQUENCY(IF(C1:C100>0,B1:B100),A1:A10)
Ctrl Shift Enter
But this will return an array, you already know that, right?

 

[Scott Fergus]

Well that was easy, thank you, and yes I want an array so all good