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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 438 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 282 Events
 32 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!