How do I count MTD coloms?
 

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,

How do I count MTD coloms?
 

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,

How do I count MTD coloms?
 

Manasvi,

If the fields are dates in some column, and hours are actual time values in column HH ?, then you
could use something like

=SUMPRODUCT((MONTH(HG2:HG2000)=9)*(HH2:HH2000.25) )

to get the count for September.

OR, if all the values are already separated by months

=COUNTIF(HH2:HH2000, ".25")

IF the values are hours as integers, and not time values, then use 6 instead of .25

=SUMPRODUCT((MONTH(HG2:HG2000)=9)*(HH2:HH20006))
=COUNTIF(HH2:HH2000, "6")


HTH,
Bernie
MS Excel MVP


"Manasvi" wrote in message
...
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,

How do I count MTD coloms?
 

opps.
i gave yo times for 6:01. change formuals to ".25"

sorry
regards
FSt1

"FSt1" wrote:

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,