Adding cells until another cell changes

I am trying create a formula to add 2 cells until 2 other cells have data placed in those cells I want to add them.

Best Answer

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Samuel,

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Samuel Dowdy Jr.
    Samuel Dowdy Jr. ✭✭✭✭✭✭
  • Samuel Dowdy Jr.
    Samuel Dowdy Jr. ✭✭✭✭✭✭

    I want it to add the projections; unless actual revenues are entered.