Prince & Anil
Thx, now working properly.
Regards,
Iqbal
On 16 January 2013 16:38, Prince wrote:
> Hi Shaikh,
>
> Just Paste these formula and enjoy.
>
> (I5 to I11)
>
> =COUNTIFS($C$2:$C$246,">=100")
> =COUNTIFS($C$2:$C$246,">=90",$C$2:$C$246,"<=99")
> =COUNTIFS($C$2:$C$246,">=80",$C$
Hi Shaikh,
Just Paste these formula and enjoy.
(I5 to I11)
=COUNTIFS($C$2:$C$246,">=100")
=COUNTIFS($C$2:$C$246,">=90",$C$2:$C$246,"<=99")
=COUNTIFS($C$2:$C$246,">=80",$C$2:$C$246,"<=89")
=COUNTIFS($C$2:$C$246,">=70",$C$2:$C$246,"<=79")
=COUNTIFS($C$2:$C$246,">=60",$C$2:$C$246,"<=69")