View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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.