Capture.PNG
In this excel file I already have the following formulas to make a daily and monthly summation;
DAILY: =IF(DAY(A3)<>DAY(A4); SUMIFS(K:K;A:A; ">="&INT(A3);A:A; "<"&INT(A3)+1); "")
MONTHLY: =IF(MONTH(A2)<>MONTH(A3); SUMIFS(K:K;A:A; ">="&EOMONTH(A2; -1)+1;A:A; "<"&EOMONTH(A2; 0)+1); "")
I now want to make an hourly summation of the quarter-hour data that's given but just changing DAY or MONTH with HOUR does not work.
Thanks for your help in advance.
Bookmarks