•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sum Offset only moving one row instead of needed 96
I'm doing solar calculations but the data is in 15min increments and I need by the day. So I'm trying to add every 96 cells in a row to add up every day but my function is only moving the starting cell down 1 at a time instead of 96.
Not sure what to change to make it work the way I need. I absolutely do not want to manually do 32,000+ rows 96 at a time.
This is the formula =sum(OFFSET($E$8,(ROWS(E8)-1)*96,0,96,1))
Sorry I can't figure out how to put pictures in a text post. My last try got auto deleted.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com