What's the correct way to use SUMIFS here?

Mike B

=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.

Amber Eakin

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?

Mike B

Actually, I figured out how to make it work.

Amber Eakin

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?

Mike B

I got strange results:

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

Mike B

Actually, I figured out how to make it work.