Count Distinct if Sum of Count Greater Than

[#1]

Hi,

I am trying to write a formula that will give me the count of IP addesses in a table where the number of occurences of that IP is over 300. I would like to put that into a text box formula so that the figure is highlighted on my dashboard. I am able to display the actual list of IPs where this occurs with the formula below within a Pivot table that has IP selected as a dimension:

=if(sum(recordcount)>300,count(IP))

In the end there are 26 IPs out of about 3000 that come up over 300 times in the pivot, I would the textbox to display 26. Any help at all would be appreciated.

Thanks.

SS

[swuehl · Accepted solution]

In a text box, try

=COUNT({< IP = {"=count(IP)>300"} >} DISTINCT IP)

[#3]

That was just what I needed. Thanks for the quick help.