Excel Tables: How to Use Structured References with the SUMIF Formula in an Excel Dashboard 

Excel Tables: How to Use Structured References with the SUMIF Formula in an Excel Dashboard
For more Excel tips and tricks visit me at www.bradedgar.com.
In this video on Excel Tables I'll show you how to use structured references for your formulas. In particular the SUMIF formula. This can be used in your Excel dashboards in conjunction with your data validation drop down lists.
The video discusses some of the best and most useful reasons for using structured references / Excel tables. They are great for ensuring that your data sets remain dynamic and it's also easy to understand what referencing you need to use in your formulas.
The structured reference allows you to use the table name and then literally just add a square bracket to include your field name or column name on the table in Excel. I'll show you then how you can reference this structured reference formula into a shape on your dashboard and then have it display beautifully.
Other Links and Resources
Using structured references with Excel tables
support.office...
Absolute Structured References in Excel Table Formulas
www.excelcampu...
Structured References
www.excel-easy....
Structured Referencing to Identify Parts of Excel Tables
peltiertech.com...
Why you should use structured references in tables
www.excelandacc...
Introduction to Structural References
chandoo.org/wp/...
Formulas and Structured Data in Excel Tables
excelsemipro.co...
Excel Tips - Tables and Structured References
excel.tv/excel...
Excel Table Absolute Structured References
www.myonlinetra...
How to Create a Dashboard in Excel
www.smartsheet...
Excel Dashboards - Tutorials, Templates, & Examples
chandoo.org/wp/...
10 Secrets for Creating Awesome Excel Tables
www.pcworld.com...
Creating an Excel Table
www.contextures...
Excel Tables - Overlooked, Yet Awesome
analyticsdemyst...