erikpendragon
New Member
- Joined
- Aug 23, 2017
- Messages
- 1
How can i average each lower level sub group and put its value in its upper level. ex
Average all the numbers in E that are a 4 and place the result above in the 3 spot.
Average all the numbers in E that are a 5 and place the result above in the 3 spot.
Average all the numbers in E that are a 7 and place the result above in the 6 spot.
Average all the numbers in E that are a 8 and place the result above in the 6 spot.
Average all the numbers in E that are a 3 and place the result above in the 2 spot.
Average all the numbers in E that are a 6 and place the result above in the 2 spot.
Average all the numbers in E that are a 2 and place the result above in the 1 spot.
i can do this manually
=IFERROR(ROUND(AVERAGE(G6:G9),0),"")
=IFERROR(ROUND(AVERAGE(G5,G10),0),"")
but this doenst update properly if i add a new task.
How can i set this up to do it automaticly.
[TABLE="class: grid, width: 1100"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Build Docs[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sub Cover Doc MAP1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Make Doc[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Gather Data[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Build Doc[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Review[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Build[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Release Doc[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Move Doc to "In Review"[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Email Manager for review signoff[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Create PDF copy and move to "Released MAPs"[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Sub Closed Knob Doc MAP2[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Make Doc[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Gather Data[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Build Doc[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Review[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Build[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Release Doc[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Move Doc to "In Review"[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Email Manager for review signoff[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Create PDF copy and move to "Released MAPs"[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody>[/TABLE]
Average all the numbers in E that are a 4 and place the result above in the 3 spot.
Average all the numbers in E that are a 5 and place the result above in the 3 spot.
Average all the numbers in E that are a 7 and place the result above in the 6 spot.
Average all the numbers in E that are a 8 and place the result above in the 6 spot.
Average all the numbers in E that are a 3 and place the result above in the 2 spot.
Average all the numbers in E that are a 6 and place the result above in the 2 spot.
Average all the numbers in E that are a 2 and place the result above in the 1 spot.
i can do this manually
=IFERROR(ROUND(AVERAGE(G6:G9),0),"")
=IFERROR(ROUND(AVERAGE(G5,G10),0),"")
but this doenst update properly if i add a new task.
How can i set this up to do it automaticly.
[TABLE="class: grid, width: 1100"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]Build Docs[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sub Cover Doc MAP1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Make Doc[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Gather Data[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Build Doc[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Review[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Build[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Release Doc[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Move Doc to "In Review"[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Email Manager for review signoff[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Create PDF copy and move to "Released MAPs"[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Sub Closed Knob Doc MAP2[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Make Doc[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Gather Data[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Build Doc[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Review[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Build[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD]Release Doc[/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Move Doc to "In Review"[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Email Manager for review signoff[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD]Create PDF copy and move to "Released MAPs"[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody>[/TABLE]