Offset last cell

asked 2018-05-19 16:55:26 +0200

unknown1001 gravatar image

Hi,

I would like to sum last three cells from column use offset formula?

Best regards

edit retag flag offensive close merge delete

Comments

What have you tried so far? Documentation: OFFSET. Include an example.

Jim K gravatar imageJim K ( 2018-05-19 17:55:22 +0200 )edit

yes i use offset for three cells but i would like to change that to have last three cells not first one

=SUM(OFFSET(Maps.C1;3;0;3;1))
unknown1001 gravatar imageunknown1001 ( 2018-05-19 21:26:51 +0200 )edit

Do you mean the three cells above the reference (this is done using negative values) or the last three cells of an unknown reference? (a.k.a. Maps.C1 is a single reference with an unknown number of rows following?)

Xoristzatziki gravatar imageXoristzatziki ( 2018-05-20 11:42:58 +0200 )edit

Thank you!, you help me with your question! I need to set up offset to sum last not empty three cell in column. So now i know i can change reference to last one and give negative number. Thank you! You can give it as a answer and i gonna give you karma.

unknown1001 gravatar imageunknown1001 ( 2018-05-20 12:25:48 +0200 )edit