I have been battling to get the COUNTIFS formula right for the below. I need to count the number of events per day. How many times did the event happen between 2021-04-20 14:24:54 and 2021-04-20 19:16:13.
absolutely losing it.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community=COUNT(FILTER(A2:A,day(A2:A)=day("04/20/2021")))
or =index(COUNTIF(day(A2:A), "="&day("04/20/2021")))
... same result
below the formula gives a calculation of 22 but should actually be 16.
i am definitely still doing something wrong.
it first gave me an error "Iterative calculation" so i switched on under file-settings.
updated the date format then arrived at the wrong calculation