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
Check out the Formula Handbook template!