Sample Header Ad - 728x90

How to COUNTIF a Date/Time in Apple Numbers

0 votes
0 answers
33 views
I have a following set of data [time] [value] ...97 lines... In another table I set intervals like [from] and [to] like 9:00 to 9:09 I'm trying to count occurrences of data in each interval by =countifs( , concatenate(", concatenate(">", [to]) ) I played with adding " to concatenate formula, timevalue. Still get 0 as a result. E.g. can't create correct condition for countifs function. Please assist!
Asked by Pavel Pervoy (31 rep)
Jul 12, 2025, 04:48 PM
Last activity: Jul 12, 2025, 06:33 PM