| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count a range of times and link it another worksheet.
Could do something like this:
=COUNTIF(A2:A10,"="&TIMEVALUE("6:00 AM"))-COUNTIF(A2:A10,""&TIMEVALUE("6:59 AM")) Note that you could replace the TIMEVALUE function with a cell reference, if you have cells somewhere that already have your limiting values. Say, B1 = 6:00 am, C1 = 7:00 am. New function is: =COUNTIF(A2:A10,"="&B1)-COUNTIF(A2:A10,"="&C1) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jay C" wrote: How do I count a range of times and link it to another worksheet. For example I am trying to count all the start times between 6:00am and 6:59am on Monday for example and link the total to a summary page. I want to set it up so that I can count from 7:00 to 7:59 and so forth. I have tried to use a count / countif and do not a solver installed so I can not use Sumproduct. Any help is greatly apprecitated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
| Count times that are more than 5 minutes in a range from a newworksheet | Excel Worksheet Functions | |||
| Count how many times a certain value is in a certain range | Excel Discussion (Misc queries) | |||
| Count the number of times a cell value is within a specific range | Excel Worksheet Functions | |||
| how do I count the number of times a word is repeated in a range? | Excel Discussion (Misc queries) | |||
Threaded Mode
