What's the correct way to use SUMIFS here?


=SUMIFS(Amount:Amount, Key:Key)

I'm trying to get a running total, everywhere the Key is the same, sum the Amounts. The first seven rows will have the same Spent amount.

Best Answers

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    Answer ✓

    Hi @Mike B - You need first the IF range, then criterion, then the column you want to SUM. Yours should look like this. You can set it as a column formula in that "Spent" column.

    =SUMIF(KEY:KEY, KEY@row, Amount:Amount)

    Does that work for you?

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast

  • Mike B
    Mike B ✭✭✭✭
    Answer ✓

    Actually, I figured out how to make it work.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!