Hello

I am trying to create a sumIF statement to add up the previous 96 cells if the date changes. In the screen shot below I have range as the entire data set, the DATE criteria, but I dont know what to do for the [sum_range] which needs to be the previous 96 cells. This is electrical energy data that I am trying to convert 15 minute interval data to energy, and the previous 96 cells add up to one hour. Ultimately this formula I am trying to do should convert 15 minute interval data to daily kilowatt hour sum. Thanks for your help!!!

=SUMIF(D3:D35235, DAY(A4)<>DAY(A3),(D3:D98))

SUMIF.JPG