Excel dashboard using Advance Excel Formulas

Amhyhosh11

New member
Joined
Sep 13, 2020
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2016

[FONT=&quot]Hi,[/FONT]
[FONT=&quot]I wanna prepare an interactive dashboard using SUMIFS formula in attached sheet. But when applying the formula, I'm getting #Value / 0 result. Basically, I want to find out Overdue invoices for all customers, with overall view (management view) on all the invoices to be tracked so that it gives me all the inputs from base sheet i.e overdue invoices, not overdue invoices, account name, aging, month wise & year wise with all the details. But when I tried for many times, I'm not getting the result as wanted.[/FONT]
[FONT=&quot]Could you please help me on this in attached sheet so that I can prepare interactive dashboard[/FONT]
[FONT=&quot]Regards,[/FONT]
[FONT=&quot]Amy[/FONT]
 

Attachments

  • DB_Invoices.xlsx
    17.6 KB · Views: 24
What formula did you try?
 
The actual formula, not a schematic, cell references and criteria.
 
Back
Top