hi
count? or sum?
=COUNTIF(A2:A8,".250690")
=SUMIF(A1:A8,".250690",A1:A8)

adjust to suit

Regards
FSt1

"Manasvi" wrote:

i have a sheet that contains date wise 3 fields Present, Login time (HH),
productivity. I would like to count Login time(HH) greater than 6 hrs for the
whole month.

Would any one can help me?

Regards,