# Getting the last Value of a dynamic column

Here is a small example

```
A B C D
```

1 45 33 (+A1+B1) 1

2 23 12 (+A1+B1) 12

3 12 21 (+A1+B1) 76

4

Okay what I am trying to do is Get the last value of Column A and C.

Here is what I have

For the value of A I use this =INDEX(A1:A999,COUNTA(A3:A999)) And returns 12, which is right, so if I add another number in column A, that value will be returned (up to 999)

Now I can't seem to make that work for column C as it contains a function, technicaly I want it to return 33 as per that example.