Excel, Accelerated: Total Amounts from Pick List Task: Total values by category Context: A budget vs. actual summary by category Acceleration techniques: Function: SUMIF Technique: Absolute referencing Object: Create a table Object: Name a table Technique: In-cell drop-down list Time: 3:47 Buy $4.99