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.
 
Hi Jay,
you don't need solver to use sumproduct please provide an example, thanks
 
Hi Jay,
you don't need solver to use sumproduct please provide an example, thanks
 
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)
 
You must log in or register to reply here.

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

Excel Count If Formula Question 1
Counting instances of a time in cells with date AND time. 8
Counting Ranges 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Changing linked worksheet and range of cells 7
Count occurences of time 1
Counting instances of data across worksheets 1
Counting occurrences in a range 3

Back
Top