Jan 09 2022 07:53 AM
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.
Jan 09 2022 07:59 AM
=SUM(C2,INDIRECT("C"&COUNTA(C:C)))
Maybe with above formula as shown in the attached file.