Hi there,
Please, I need help with this.
I have a series of hourly temperature data (C) for a year (N=8760) and I need to:
A) Count the number of cells (Column B) between this time range in a year: 01:00 to 08:00 AND 23:00 and 00:00.
I know the result is 2920 and would like to get that without using filter with SUBTOTAL.
B) Count the number of cells at the same time range that are lower than 30, in column C.
Year.jpg
I have been working with that, obtaining a partial solution using COUNT.IFS for a day (just one time interval), but when I have a year and different time intervals in a day….
Best regards,
Bookmarks