Sheet Summary Formula with Indent Data

Kevin7859

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), "")

James Keuning

Create a new column called Parent, and put this in it: =PARENT([Region Size]@row)

Then you can use SUMIF, pointing at the Parent field.

James Keuning

Create a new column called Parent, and put this in it: =PARENT([Region Size]@row)

Then you can use SUMIF, pointing at the Parent field.