Displaying the contents of a cell based on value if others

[Paul Naylor]

Hi, hoping someone can help

I have a number of weekly spreadsheets with data on daily tabs ( which comprise of work c/f & new work in and completed) and a weekly total tab with work c/f , new work in and completed for each day.

What I need is a formula that will display the contents of a cell based on the value of 2 cells added together.

E.g. weekly total worksheet

Column C is daily carried forward totals ( Monday is in C7) let's say value is 500
Column D is Daily New In figure ( Monday is D7) let's say value is 1000

So I need a formula ( or VBA) that will display the contents of the sum of these(1500) or the last entry on a particular column of a specified sheet column D ( which will be the time of the last entry on the sheet) this will allow me to check all work been added without actually opening the spreadsheets.

Anyone any ideas best way to achieve this

Kind Regards,

Paul

 

[Paul Naylor]

Hi , no need managed to find a solution ( display the last entry in a column on a worksheet :

=INDEX(C:C,MAX(MATCH(9.99999999999999E+307,C:C),MATCH(REPT("z",255),C:C)))