How to generate new row in existing column with a formula?

[prernaaher]

Hi,

Please check the attached table. I want to add a new row "PD" in the 'Function' column. 'Technology Innovation_Advancement'  numbers for "PD" will be the addition of functions  "AS" + "DPT" + "DST" + "D&FDPT" . And same formula for 'TOTAL_FTE'.

Stuck on this for a very long time. Please advise,

Thank you so much!

[afv2688 · Accepted solution]

Hello @prernaaher ,

how about this solution?

Regards

[Qiu · Accepted solution]

@prernaaher 
Not sure about the other two columns.

[prernaaher]

Thank you so much! This was really helpful 🙂

[prernaaher]

Thank you so much! This is really helpful and I tried it.. it works perfect!