SUMIFS with multiple matches

jludford94616

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,...

Paul Newcome

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........................................)