Excel additon functions

Occasional Visitor

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

@EChartier 

=SUM(C2,INDIRECT("C"&COUNTA(C:C)))

 

Maybe with above formula as shown in the attached file.