Hi Sumesh,

Am Fri, 13 Apr 2012 14:52:39 +0000 schrieb sumesh56:

-----------------------------
A B C
-----------------------------
SL.NO TITLE
-----------------------------
1 abc 1
2 wett 1
3 0
4 jkhghj 1
5 0
6 0
7 rloljo 1
8 0
9 0
10 fddde 1
11 0
12 rderu 1

try in B2:
=--SUBTOTAL(3,$B$2:B2)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2