I would like to have a formula to add the numbers in one column based on the outline_level in another column. The issue at hand is I have an outline level that starts with 1, then 2, then 3. I will have one level 1, multilple level 2's, with lots of level 3's under each level 2.
Example:
Column B Column K
Outline_Level Hours
1 total of all level 2's
2 total of level 3's under this level 2 (not to include the next level 2)
3 hours
3 hours
3 hours
3 hours
2 total of level 3's under this level 2 (not to include the next level 2)
3 hours
3 hours
3 hours
I have a couple of formulas already for the level 1 and level 2, but cannot figure out how to stop at the next level 2.
SUMIF(B9:B613, 2, K9:K613) (sums all the level 2's for the level 1 effort)
SUMIF(B10:B614, 3, K10:K614) (sums all the level 3's under the level 2 effort)
Any help would be greatly appreciated.
Bookmarks