Forum Discussion
Unusual Excel Help Request, Perhaps
Hello,
I'm sorry thing is lengthy, but I desperately need assistance with the following problem:
I have a worksheet where Tab A is divided into two sections (say Peter and Stephen). Each contain a column where I start with the beginning value for the month (say X). Then on the row below I manually enter a value for the first day (say Y). On the third row I use a SUM function to total X and Y. I then repeat the process each day so the current total is shown every three rows. This is done for both sections. Pretty straightforward so far...
However, on Tab B, I want to keep an up-to-date total of the most recent totals for both Peter and Stephen, which changes every day. SUM will only allow a pre-chosen cell, whereas I want it to use the most recent Tab A totals as the days go on, so I have the most current total on Tab B.
However, I don't know what function to use (and how to configure) so that it will total only the most recent totals, basing it on the latest totals and not specific cells.
If anyone can help, I would be extremely grateful.
Regards, Dave
Let's say you want to return the last value of column D om Tab A
=LOOKUP(9.99999999999E+307, 'Tab A'!D:D)
- Thank you for responding. To clarify, this would return the last total from column D regardless of it's row? And how do I combine it with the last total from column F on Tab A to a cell on Tab B?
> this would return the last total from column D regardless of it's row?
Yes, indeed.
The last total for column F would be
=LOOKUP(9.99999999999E+307, 'Tab A'!F:F)
If you want to add them together:
=LOOKUP(9.99999999999E+307, 'Tab A'!D:D)+LOOKUP(9.99999999999E+307, 'Tab A'!F:F)
