Sheet Summary Formula with Indent Data

Trying to create a sheet summary formula to calculate the cost/project of indent data based on the outdented criteria:

So if the Regions size is Large then calculate the cost/project for all regions, I've only shown 2 as an example but this encompasses 80 regions of sizes 1-5 with multiple project names. the count of projects shown is a total of all projects but some are short term, mid term and long term.

So I tried sumif, averageif, If(Region size=2-small, sum(sumcost of projects/count of projects), "")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!