Adds the total of cells in a range based on multiple criterion. Improved audio quality. SUMIFS Formula in Excel sums cells in a range that match supplied criteria. Unlike the SUMIF function, SUMIFS formula can apply more than one set of criteria, with more than one range. The first range is the range to be summed. The criteria is supplied in pairs (range/criteria) and only the first pair is required. For each additional criteria, supply an additional range/criteria pair. Up to 127 range/criteria pairs are allowed. 10 Most Used Formulas MS Excel
