Forum Discussion
EChartier
Jan 09, 2022Copper Contributor
Excel additon functions
I need to add the last value in a table column to the first value in the same table column. The last value is not a fixed cell, it will move as I add new data.
1 Reply
- OliverScheurichGold Contributor
=SUM(C2,INDIRECT("C"&COUNTA(C:C)))
Maybe with above formula as shown in the attached file.