What formula do i need?

I'm trying to get a running total based on if a certain drop down is used, in this case its value income total value. So if sales income is used multiple times i need the running total?

Best Answer

  • Isis Taylor
    Isis Taylor ✭✭✭✭✭✭
    Answer ✓

    @StevieC This formula should work.

    =SUMIFS(Value:Value, [Sub-Contract]:[Sub-Contract], "Sales Income")

    Isis Taylor

    🎓️ Core App and Project Management Certified 🏅

    🌟Peer Connect, Mobilizer, and Early Adopter Program

    Business Analyst Senior

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!