How do I count MTD coloms?

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,
 
F

FSt1

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

adjust to suit

Regards
FSt1
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Sum in Excel 1
Specify MTD Diff by month's columns 0
Specify columns to add for months MTD Diff 3
specify which month's columns to use in mtd calculation 0
COUNTING THE SAME VALUES IN A SHEET 3
how do I get a result if one cell is X and the 2nd cell is Y where 6
Link Drop Down with Pivot Table 2
COUNT question 4

Top