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

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

Actually, I figured out how to make it work.
Answers

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

I got strange results:
=SUMIF(Key:Key, Key@row, Amount:Amount)

Actually, I figured out how to make it work.
Help Article Resources
Categories
Check out the Formula Handbook template!