Sum(children()) + sumifs (rows underneath, criteria 1, rows underneath, criteria 2)
I have a budget divided by department and subdepartment. the parent rows rollup the children rows to tell me the grand total for each subdepartment budget. I'm then creating a dynamic view of each subdepartment budget and giving the heads of those subdepartments the opportunity to add new rows (via dynamic view). I would like the Total cell to include the children PLUS any additional rows that meet a certain criteria (ie: department code AND level 0).
Help Article Resources
Check out the Formula Handbook template!