So I have an excel file over some years with 10min values [A2;A181441].
I want to SUM every row of 144 values into [C2;C1261].
Looking forward to your answers!
edit: Thanks @Rajesh S for update: Row of 144 values not every 144th value.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communitySo I have an excel file over some years with 10min values [A2;A181441].
I want to SUM every row of 144 values into [C2;C1261].
Looking forward to your answers!
edit: Thanks @Rajesh S for update: Row of 144 values not every 144th value.
This will solve the issue:
N.B.
Formula in Cell E98
:
=SUM(OFFSET($B$98,(ROW()-98)*5,0,5,1))
Your Formula should be written like this.
=SUM(OFFSET($B$98,(ROW()-98)*144,0,144,1))
A1:B1000
along with headers in Row 1 then use this Formula in Cell D2
.=SUM(OFFSET($B$2,(ROW()-2)*144,0,144,1))
Adjust cell references in the formula as needed.
Here is an alternative that uses Index()
rather than Offset()
:
=SUM(INDEX(A$2:A$181411,1+144*(ROWS($1:1)-1)):INDEX(A$2:A$181411,ROWS($1:1)*144))
and copy downward.