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
PReagan's avatar
PReagan
Bronze Contributor
Aug 27, 2020

Hello UC_Chick,

 

Perhaps the SUMIFS() function is what you're looking for. As HansVogelaar noted, the data seems incomplete so it would be difficult to provide an exact formula for you to use.

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

    PReagan Yes that is what I am looking for.  I can't figure it out.  Attached is a corrected version-I forgot to change the names

Resources