•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
#real-time data collaboration
#Excel alternatives for data analysis
#real-time collaboration
#row zero
#AI formula generation techniques
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#intelligent data visualization
#data visualization tools
#formula generator
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#Excel
#OFFSET function