Sum of hourly values as sum into next sheet

[Emil123]

Hello,

I am new to Excel and somehow can't figure out how can I transfer sum of hourly values into single row of a new sheet, then into another row put sum of a new day and so on.
Let's say I have almost infinite range starting with E8 separated into days by hourly values starting from 6:00. What I want is to make sum of each day into new sheet and then by simple dragging fill the other cells into the end of the sheet.

Thanks for your help and sorry for bad English

Emil

[BadlySpelledBuoy]

You can use SUMIFS to perform what I think you mean.

In the attached I've put some random numbers against hourly slots for several days on Sheet1 then on Sheet2 I've summed those values by day using the below formula:

Please Login or Register  to view this content.

There is more than one way of accomplishing this including the use of Pivot Tables.

BSB

[Emil123]

Thank you very much, it works!

Greatly appreciated ��