Forum Discussion
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 ...
=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?
