Displaying the contents of a cell based on value if others

Paul Naylor

New Member
Joined
Sep 2, 2016
Messages
44
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
 

Some videos you may like

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
Joined
Sep 2, 2016
Messages
44
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)))
 

Watch MrExcel Video

Forum statistics

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