Forum Discussion

rkoning's avatar
rkoning
Copper Contributor
Jul 14, 2023

Excel Formula Help

I have created an Excel Workbook for a month's worth of data with a tab for each day. Each of my days are calculating correctly as a percentage, however, I cannot get the percentage calculation to populate on the monthly tab.

  • OkenAnalytics's avatar
    OkenAnalytics
    Brass Contributor
    How have you tried to calculate the monthly percentage? Can you paste the formula here?
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    rkoning You are not disclosing much to work with, but a good start would be to put all data in one sheet rather than one sheet per day. Excel has many powerful analysis tools that work best on a single database. Can you share a link to your file on Onedrive or similar?

Resources