←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Power query how to sum specific rows

Our take

Power Query can streamline your data management, but it often feels cumbersome for simple tasks like summing specific rows. Many users share your frustration, especially when basic operations seem to require multiple steps. If you consistently need to sum rows 14+15, 34+35, and 54+55, you deserve a straightforward solution. While advanced transformations have their place, the challenge of achieving simple calculations efficiently highlights a gap in user experience.

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]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#rows.com