Forum Discussion
Add row and copy formula
Hello, I wonder how I add an entire row and take the formulas from below. And also, I'm adding a row at the top side, and I have 1 parameter that calculates the las 13 data. By that I need the oldest...
https://1drv.ms/x/s!As3uG0-FXb_-h0oL_c61aqxD7fmO here is a link of my chart
This is your data converted to a Table. The yellow cells contain the formulae
= SUM( TAKE(Table1[LongBI], 13) )
= SUM( OFFSET(Table1[LongCH],,,13) )Thanks PeterBartholomew1