Excel - help needed.

[TheOldhamWhisper]

I could be missing something blindingly obvious here, but I need to reference the last cell in a column that holds data and update the cell that holds the value as the reference moves.

EG

Last cell is A20 and I add another row - Last cell is now A21. I have a cell which references A20, how do I automatically get it to reference A21?

[plater]

Hi Oldham,
I'm still a bit green on excel but I just added the if Function below and it looks for the first blank cell (NO DATA), probably a bit crude but it worked.

=IF(A1="",SUM IF TRUE,SUM IF FALSE)

Just put in the formula you use for Sum if true / false.

Plater

[TheOldhamWhisper]

Hi Oldham,
I'm still a bit green on excel but I just added the if Function below and it looks for the first blank cell (NO DATA), probably a bit crude but it worked.

=IF(A1="",SUM IF TRUE,SUM IF FALSE)

Just put in the formula you use for Sum if true / false.

Plater

Cheers Plater - I'll try it out. Crude is OK as long as it does the job.

[Onlyforfun]

Hi Oldham, have put a solution in another thread (platers places thread ) where you two were discussing it. Hope it helps.

[TheOldhamWhisper]

Thanks for your help - Rep points on the way.