SUMIF Formula help

Options

Column A has various business units and column B has the number of resources. I am trying to sum the total number of resources for each primary business unit. The challenge is some business units have subunits and i need to include these in the sumif formula to get the total number of resources for all related business units please see example below the yellow number is the target formula result


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!