SUMIFS

The SUMIFS function in Excel is a function that allows you to sum the values in a range of cells based on multiple criteria. The syntax for the SUMIFS function is as follows: SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...). The "sum_range" is the range of cells that you want to sum, and each "criteria_range" and "criteria" pair specifies a criterion for including a cell in the sum. For example, to sum the values in the range A1:A10 where the values in the range B1:B10 are greater than 5 and the values in the range C1:C10 are less than 10, you would use the formula =SUMIFS(A1:A10, B1:B10, ">5", C1:C10, "<10").