Children sum formula total calculations
I have a formula issue that has stumped me. My use case is basically summing up all of the Job income per quarter. Our jobs often have differnt phases which are simply indented to the job itself. My primary Job rows are set to =SUM(CHILDREN) while the total wrap is just set to =SUM of all rows. My question/issue is that I need my main total wrap calculation to only factor in the Job parent row sums and not the children numbers as well. If you look at the attached screenshot, you will see its counting everything when I only want it to count the parents, in this example, it should only read $6. I know I can do this cell specific but we may create dozens of these Jobs parent rows with subsequent children rows underneath it so I dont think individually picking each cell for this calculation is efficient. Anyone know of a way for me to sum up ONLY the parent rows?
Help Article Resources
Check out the Formula Handbook template!