Forum Discussion

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...

Example.xls29 KB

Formulas and Functions

MVP

Aug 27, 2020

How do we connect the names Provider A etc. in column A to the names Hurley etc. in column G?

Copper Contributor

Aug 27, 2020

HansVogelaar see edited excel

Example.xls29 KB

HansVogelaar
MVP
Aug 27, 2020
UC_Chick

The attached version demonstrates a solution using SUMIFS formulas, and also a pivot table.
Example.xlsx14 KB
- UC_Chick
  Copper Contributor
  Aug 27, 2020
  HansVogelaar this is wonderful! Thank you very much for all of your help!
  - 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.
PReagan
Bronze Contributor
Aug 27, 2020
UC_Chick

Please refer to the attached workbook.
Example.xls.xlsx11 KB
- UC_Chick
  Copper Contributor
  Aug 27, 2020
  PReagan it won't work for me. I am trying to sum each type of leave for each provider. The sums should be filled in under the respective type (H-O) and provider row (G).
  - PReagan
    Bronze Contributor
    Aug 27, 2020
    UC_Chick
    
    Sorry, I think I misinterpreted what you were requesting. Is this what you were looking for?
    Example.xls.xlsx13 KB

Resources