How do I count MTD coloms?

  • Thread starter Thread starter Manasvi
  • Start date Start date
M

Manasvi

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,
 
hi
count? or sum?
=COUNTIF(A2:A8,">.250690")
=SUMIF(A1:A8,">.250690",A1:A8)

adjust to suit

Regards
FSt1
 
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:HH2000>6))
=COUNTIF(HH2:HH2000, ">6")


HTH,
Bernie
MS Excel MVP
 
Back
Top