I have two sheets one with date/times, and names in columns that gets populated automatically from a form submission, and a second one that has dates only across the columns with names down the rows. I am building a countif formula that will count all entries on the form submission page that match the name of the person on the date.
I have made it work for another sheet setup where the entries are added manually through the use of a helper datevalue() cell which pulls the datevalue() from the date and time filled cell and then matches it to the datevalue() of the header cell on the second sheet.
Essentially for each date and name on the grid, it counts if that person did an entry on that day.
My other sheet populates automatically and so I cant use the helper column because the import automation overwrites blank cells using standard criteron doesnt seem to work because of the times in the cells. So having a hard time getting the count to work because it doesnt match the top date.
=COUNTIFS(Sheet1!B:B,$A3,Sheet1!A:A,">="&B$2,Sheet1!A:A,"<"&(B$2+1))