How to get count and Sum of freq in Text boxs

[#1]

Hi All,

I have to calculate the count of country names having frequency >=3 and sum of frequency .I am attaching sample data as shown in sheet 1. i did manual calculation in sheet 2.

Could you please help me in solving the prob .

Thanks,

Rahul

[MK_QSL · Accepted solution]

Use Below in TEXT BOX at UI end

=SUM(IF(AGGR(COUNT([Country Name]),[Country Name])>=3,1,0))

and

=SUM(IF(AGGR(COUNT([Country Name]),[Country Name])>=3,Aggr(COUNT([Country Name]),[Country Name]),0))

[#3]

Thanks Manish