Excel Magic Trick 1329

Clean Data Then Add w 2 Criteria: SUMIFS or Power Query (Get & Transform)?

DESCRIPTION

See how to Clean a data set and then add with two criteria using SUMIFS function and Wildcards with the criteria or Power Query and Group By feature:
(00:14) Introduction
(01:44) SUMIFS function and Wildcards with the criteria
(05:25) Power Query and Group By feature
(12:03) Summary

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply