Forum Discussion
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 need to have an on-going sum of each type of leave for each provider.
16 Replies
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.
How do we connect the names Provider A etc. in column A to the names Hurley etc. in column G?
HansVogelaar see edited excel
The attached version demonstrates a solution using SUMIFS formulas, and also a pivot table.
the names in column G should be the Provider A,B, C, D, E. I forgot to change that. This is where I want to total each type of leave for each provider.
