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

  • Thread starter Thread starter Jay C
  • Start date Start date
J

Jay C

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.
 
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)
 
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)
 
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)
 
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)
 
Back
Top