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,...
Help Article Resources
Check out the Formula Handbook template!