I have a spreadsheet report -- used to monitor our marketing campaign reports. So my goal here is to be able to update a cell showing the our current spending as of yesterday.
How can I go about doing this? Please advise.
Sample data would look like:
Date | Cost | 01/01 | 2.50 | 02/01 | 3.50 |
I want the cell to update daily with the latest cost data. Is this possible? Using what formula.