Results 1 to 4 of 4

Thread: Excel dashboard using Advance Excel Formulas

  1. #1
    Neophyte Amhyhosh11's Avatar
    Join Date
    Sep 2020
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Excel dashboard using Advance Excel Formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!


    Hi,
    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.
    Could you please help me on this in attached sheet so that I can prepare interactive dashboard
    Regards,
    Amy
    Attached Files Attached Files

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,818
    Articles
    0
    Excel Version
    O365
    What formula did you try?

  3. #3
    Neophyte Amhyhosh11's Avatar
    Join Date
    Sep 2020
    Posts
    2
    Articles
    0
    Excel Version
    2016
    Quote Originally Posted by Bob Phillips View Post
    What formula did you try?
    =SUMIFS, sum range, criteria range, criteria range 1

  4. #4
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,818
    Articles
    0
    Excel Version
    O365
    The actual formula, not a schematic, cell references and criteria.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •