Forum Discussion

UC_Chick's avatar
UC_Chick
Copper Contributor
Aug 27, 2020

Formula Help

I am trying to figure out how to sum a particular type of vacation leave for particular providers.  There are 9 different types of leave, minimum of 5 providers, and hours for each day of leave.  I n...
Formulas and Functions
  • UC_Chick's avatar
    UC_Chick
    Copper Contributor
    Aug 27, 2020

    HansVogelaar this is wonderful!  Thank you very much for all of your help!

    • PReagan's avatar
      PReagan
      Bronze Contributor
      Aug 27, 2020

      UC_Chick 

       

      You're welcome. Happy to help!

       

      While it is not necessary to format your data as a table, I always find it to be good practice. In your case, your formula would need to be modified slightly should the data not been formatted as a table.

      • UC_Chick's avatar
        UC_Chick
        Copper Contributor
        Aug 27, 2020

        PReagan I am still having issues.  The formulas are giving me 0 sums when they should not be 0.  I have attached a shortened version of what I am actually working on.  To note, I would like to be able to add on and have this be a working copy, so I made the table to include additional rows that are currently blank.  Any suggestions? 

Resources