| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| How to expand coloms beond the last avaliable one in a Worksheet | Excel Discussion (Misc queries) | |||
| Fixing the number of Coloms and rows. | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| removing duplicates testing in 2 coloms | Excel Worksheet Functions | |||
Linear Mode
