Power Query: Summing Data from Specific Ranges

This is a CRAZY one!

Kevin Lehrbass presented this problem:
A tall stack of mini data ranges that need to be totaled. BUT!

Only total the ranges that say “TOTAL.” Ignore the ranges that are labeled anything else.

(Kevin’s solution:
https://www.youtube.com/watch?v=oomf8bfcFEw)
Kevin’s video shows various formula solutions. My video shows a Power Query (Get and Transform) solution using:
– Import data from another workbook
– Fill Down
– Add Custom Column
– Grouping with multiple aggregations

Download the solution:
http://datascopic.net/sumranges
Subscription link:

Channel Blurb:

Contact me:

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *