How do I count a range of times and link it another worksheet.
 

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.

How do I count a range of times and link it another worksheet.
 

Hi Jay,
you don't need solver to use sumproduct please provide an example, thanks

"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.

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.

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.