# Displaying the contents of a cell based on value if others

#### Paul Naylor

##### New Member
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

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### Paul Naylor

##### New Member
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)))

Replies
2
Views
105
Replies
1
Views
32
Replies
1
Views
70
Replies
3
Views
49
Replies
1
Views
125

Threads
1,118,075
Messages
5,570,051
Members
412,309
Latest member
essobsan