Forum Discussion
Countifs trouble
I have to keep track of request sent in daily by different people i got =COUNTIFS(Table1[Completion time],Sheet1!$B$1,Table1[Name],Sheet1!$A$2) to kinda work. The problem i am running into is on t...
Xenju1 I see you have time value with data in table. So, only comparing with date, will not work. You must compare with date+time to count date/time values. Try the following formula-
=COUNTIFS(Table1[Completion time],">="&Sheet1!$B$1+TIME(0,0,1),Table1[Completion time],"<="&Sheet1!$B$1+TIME(23,59,59),Table1[Name],Sheet1!$A$2)