Forum Discussion
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".
=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?
3 Replies
- OliverScheurichGold Contributor
=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?
- alexw94Copper ContributorOliverScheurich, the numbers are in time, HH:MM:SS.
- Detlef_LewinSilver Contributor