Forum Discussion
Solved
Annual Quarter Hourly production converted to hourly production values
Hello, I am working on a production report that displays production values on a Quarter hourly basis. I need to be able to convert the quarter hourly data to hourly data. The quarter hourly data ...
In W28:
=SUMPRODUCT(J$28:J$35067, ($H$28:$H$35067=$U28)*(HOUR($I$28:$I$35067)=HOUR($V28)))
Fill to the right to AA28, then down to row 8787 (or vice versa)
In W28:
=SUMPRODUCT(J$28:J$35067, ($H$28:$H$35067=$U28)*(HOUR($I$28:$I$35067)=HOUR($V28)))
Fill to the right to AA28, then down to row 8787 (or vice versa)
This worked perfectly, Thank you