Excel Power Tip - Switch Formula Sheet Names Dynamically using INDIRECT and SUMIFS

Hi Excel Users,

Showing you the power and versatility of Excel's INDIRECT function that can be used with a cell drop down to Dynamically switch sheet names within several SUMIFs formulas. This enables interactive dynamic user sheet selections and sheet versus sheet comparison when calculating numbers like Sales and Profit for different Product Sub-Categories.

This approach can be used to create locked dashboards and calculated tables if you prefer not to use Pivot Tables.

Thanks for watching.

Скачать видео