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...
If you are inputting basic data, this is best done using an Excel table. To insert values at the top requires you to insert a row to the sheet, but any formulas should extend to include the new row. Using 365 a formula to return the sum of the top 13 items of a value field would be
= SUM(
TAKE(Table1[value],13)
)Similar things can be done using INDEX:INDEX
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