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:
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:
Subscription link:

Channel Blurb:

Contact me:

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2