SUMIFS with multiple matches
I am trying to create a Smartsheet SUMIFS formula where if the value in a cell in column 1 is not blank, and the value in a cell in column 2 is US Commercial, and the value in a cell in column 3 is 2019 and the value in a cell in column 4 is 4.. I.e. for any rows where there is a match for - deal id is not blank, where that row is tagged as US Commercial, in FY2019 and Quarter 4 - sum the $ value present in column 5 "target revenue value".. what I want to end up with is a table that says total value FY19Q4 US Commercial - and it generates a sum from all matches,...
Comments
-
Try something like this...
=SUMIFS([Sum Column]:[Sum Column], [1st Criteria Column]:[1st Criteria Column], 1st Criteria, [2nd Criteria Column]:[2nd Criteria Column], 2nd Criteria........................................)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!