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.

  • This question doesn't show any research effort. Please checkout How to Ask. – Rubén Oct 15 '16 at 20:11

You need to use SUMIF() function. Example

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.