Excel Magic Trick 1149

Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)

DESCRIPTION

See how to:
Dynamically Sum Costs by Category without VLOOKUP Helper Column:
(00:47) VLOOKUP helper Column and SUMIFS function
(03:10) Array Formula using SUMPRODUCT and LOOKUP functions
(06:23) Test to see if formulas update dynamically or automatically
(07:07) Excel 2013 Data Model & Relationships

WORKBOOKS




Be the first to comment

Leave a Reply