COUNTIFS in Power Query? Excel Magic Trick 1549

Download Excel Start Files: http://bit.ly/2tSGcWC EMT1549-1550.xlsx
Entire page with all Excel Files for All Videos: http://bit.ly/1kSFWvs

In this video learn how to use the Power Query Group By feature to simulate the COUNTIFS function. See how to count with one condition, See how to Count with Two Conditions

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.