Solved - Formula to pick the last running total (Solved)

[rajkenya1]

Hi Guys


I am trying to figure out a formula in cell E16 which will essentially pick the last value from a cell i.e in the E column.


For example in the attached spread sheet each month there is an addition to the initial amount which makes a total amount in column E. What I need in cell E is a formula that will pick the last total. So if I add a value in cell E6 than cell E16 should pick that automatically and similarly if I add a value next in cell E7 month than cell e16 should pick the latest value automatically.

See attached spreadsheet


Please help.


Thanks

 

[Somendra Misra]

Hi Raj,

Go with below formula in E16:

=LOOKUP(99^99,$E$3:$E$14)

Regards,

 

[Nebu]

Hi:

Hope this is what you are looking for

 

[rajkenya1]

Thank Master Champ

Works perfect

Hi Raj,

Go with below formula in E16:

=LOOKUP(99^99,$E$3:$E$14)

Regards,

 

[rajkenya1]

Thanks Nebu

This also works perfecto.

Problem solved.

Thank you

Hi:

Hope this is what you are looking for

 

[Somendra Misra]

@rajkenya1

Glad you solved it & thanks for the feedback. Kindly mark your thread as SOLVED.

Regards,

 

[rajkenya1]

Thanks Somendra

How do i mark it solved?

Cheers

 

[Somendra Misra]

Edit the title of the thread and put in [SOLVED] in it.

Regards,