This video demonstrates how to use the SUMX function in Excel's Power Pivot add-in.
------------------------