Forum Discussion

alexw94's avatar
alexw94
Copper Contributor
Apr 24, 2023
Solved

Please help - COUNTIFS formula between 2 different time periods returning 0 all the time

So I am trying to get a value to to be returned in the following formula. I have a list of data on "Sheet 1" which shows a list of people and a number times during the 24 hour clock. I am wanting to get a count of how many times an occurrence came up between each hour.

 

The formula I am using is returning 0 each time, even when I fill handle it and put the $ signs before so its taking into account consecutive cells. 

 

Against cell A2 (Sheet 5) 00:00 will display occurrences between 00:00 and 01:00 and so on. 

 

This is between 2 different sheets on excel, the data is on "Sheet 1" and needs to be brought across to "Sheet 5".

  • alexw94 

    =COUNTIFS(G:G,">="&A2,G:G,"<"&A3)

    The formula works in a similar example. Are there values between 0 and 1 in your Sheet1 column D?

     

Resources