1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Power query how to sum specific rows

I will always just need to sum rows 14+15, 34+35, and 54+55. I just want m code that adds rows x+y. Why is this so difficult???

Edit: I know I can do more transformations. But am I the only one who find it ridiculous that I have to do 6 steps just to add 2 rows? Should be 1 line of code. This is why I prefer VBA lol

Edit2: This is incredibly fascinating. Given we all use excel, I hope we can all agree adding 2 rows is as basic as getting out of bed. Yet all of you are unironically telling me all these steps to take in order to accomplish such an easy task without any self awareness. I mean, if you had to take 6 steps to get out of bed, you wouldn't find that ridiculous? And everyone who says I am using the wrong tool also fails to realize the fact that such steps exist demonstrate real life requirement for it lol

submitted by /u/taylorgourmet
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#Excel alternatives
#natural language processing for spreadsheets
#self-service analytics tools
#generative AI for data analysis
#real-time data collaboration
#real-time collaboration
#self-service analytics
#Power Query
#rows
#sum
#Excel
#add two rows
#M code
#VBA
#transformations
#steps
Power query how to sum specific rows