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
Last activity: Jul 12, 2025, 06:33 PM