Creating a Dashboard using Formulas

Options

Hello,


I'm creating a dashboard and I am trying to figure out how to add two different sections (a CAR and Task). I am looking how to add how many CAR's and how many Task were issued for each month. I do have a formula page that states how many for each but I'm not sure how to state per month to be included. Please advise! Thanks in advance!

Best Answer

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Answer ✓
    Options

    =SUM(Select the cells you want to sum)

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

Answers

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Options

    You would need to create a formula on that page that counts for the items per month, or if you have it to where a SUM function could SUM the counts to make up the month, do that. I would need to see a screenshot of your sheet to be able to say which one I would do, maybe even your formula too.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

  • Nkeiruka. Aguocha
    Options

    I also wanted to add, on my formula page, I have how many CAR's and Task per month (not separate, a total of) How would I add those together? Thanks!

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Answer ✓
    Options

    =SUM(Select the cells you want to sum)

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."