Forum Discussion
Excel Dashboard for Invoices
Hi, I wanna prepare an interactive dashboard using SUM IFS formula in attached sheet. But when applying the formula, I'm getting #Value / 0 result. Basically, I want to find out Overdue invoices ...
Please see attached.
To produce interactive dashboards we must use PivotTables, Slicers and Pivot Charts. The PivotTables do the equivalent of SUMIFS with a lot less effort. Their amounts can also be double clicked to drilldown into the raw data (not possible with SUMIFS).
Slicers provide interactivity. They filter the PivotTables by whatever is in the data. And the Pivot Charts will respond to however the slicers have filtered the data.
Attache is a quick example. Hope that helps