I need to implement a 'Countif' function from Excel in crystal report.

As you know Countif function will count the same values and display the result(Count) where ever the value is located.

Name Countif
A        3
A        3
B        2
C        1
A        3
B        2
D        1


So how can I implement this in Crystal reports.

I need to display this at GF4 level.

Hi Sastry, please check the below example.

Column 1        Column 2        Count
xxxx1           yyyy1             0.33
xxxx2           yyyy2             1
xxxx3           yyyy3             0.5
xxxx4           yyyy1             0.33
xxxx5           yyyy1             0.33
xxxx6           yyyy3             0.5

in the above example we have 3 yyyy1 and 2 yyyy3... so for those records we have to display 1/3 for yyyy1 and 1/2 for yyyy3 and 1/1 for yyyy2... This should be done for all records in the report having similar column 2 values.

Is there any crystal function that i can use.

No they are not in same sort order. There are 4 groups and we have to do this is GF4. Gf4 is on column2 and remaining 3 groups are on different columns.

Also we need count of the column 2 values present in group 4,
for example count of yyyy2 is 2 in group 4 and 5 when we consider detail section.