•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
Our take
It sounds like you're facing a challenge with your SUM and OFFSET formula in your solar calculations. Instead of moving down 96 rows as needed, your function is currently only progressing by one row at a time. To address this, you might consider adjusting your formula to ensure it correctly references the intended range. Exploring the OFFSET function's parameters will be key to achieving the daily aggregation you need without the burden of manual calculations.
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]
Read on the original site
Open the publisher's page for the full experience