Sep 16 2022 03:55 AM
I have got a (long) colum of 15 min values and I want to get houly values by summing up the quarterly values
what is the easiest way to get a column of hourly values?
Sep 16 2022 04:02 AM
@Pepo1405
=SUMPRODUCT((HOUR($A$2:$A$22)=D2)*$B$2:$B$22)
You can try SUMPRODUCT.