Hi all,

I'd like to use MAXIFS to find the max energy demand between certain hours (16:00 to 21:00). Energy values are in column C and Date/Time is in column A.

My desired function: =MAXIFS(C3:C288,A3:A2882,AND(HOUR(__)>=16,HOUR(__)<21)) I'm stuck because the HOUR function only takes in a serial number and not an array.

I got it to work by using another column to calculate the hour and running MAXIFS on this, but I'd like to know if there's a way to accomplish this without making another column.

Thanks!