VBA sum every 24h for the past 20 years!

Hi,

please see the attached excel.

I have a long data showing how much power is being produced every hour of a day for a whole year. I need to have the daily production, sum every 24h, and create the second table and then the third table which includes daily production over a year. I used

Please Login or Register  to view this content.

, however, I found a few errors while using it (e.g. the power produced in 30.12 was 0, which is impossible). I can't go threw all data to find the mistake because I have multiple tables similar to this one and need to analyse the power production in the past 20 years...

Can someone help with this?

in excel I only put the data for Jan. to Feb. 3rd.

thanks

I made a table of the data. => insert => table.


With a formula to get the date.

D2=DATE(YEAR(A2),MONTH(A2),DAY(A2))


After that a pivot table.

See the attached file.

But my pivot table give you the total production on a day.

And since you also want to know the production of each hour on a day I made that pivot table in another sheet.


See the attached file.