Array Formula Sumif

The SUMIF() and COUNTIF() functions can only evaluate a single criterion.

The SUMIF() and COUNTIF() functions can only evaluate a single criterion. Sometimes, however, we may want to sum a range of values that meet multiple criteria, which is a good use of array formulas. For example, in the following spreadsheet, we want to sum the amount of each Account // Job combination, but the SUMIF() function only accepts one argument. Note that braces surround an array formula.

The braces cannot be typed in but are entered automatically by Excel when you enter the formula by pressing CTRL-SHIFT-ENTER. An array formula can do multiple calculations in a single cell or render multi-cell results from a single calculation. In this case, the array formula performs multiple calculations per cell.
4_array.htm

Leave a Reply