SUMIFS

Designates the cells whose values are summed. In this case, sum-range does not have to have the same size and shape as cell-range-1 through cell-range-n. The actual cells that are added are determined by using the top, left cell in sum-range as the beginning cell, and then including cells that correspond in size and shape to cell-range-1 through cell-range-n. Each cell in sum-range is summed only if all of the corresponding criteria specified are true for that cell. Cells in sum-range that contain TRUE evaluate to 1; cells in sum-range that contain FALSE evaluate to 0.

Designates the first range of cells to be inspected.

Specifies the criteria for the first range of cells that will be counted. In the case of text, selection-criteria-1 can consist of any comparison operator followed by the operand against which each cell's value is to be compared. selection-criteria-1 can include one or more wildcard characters, question mark (?) and asterisk (*). A question mark matches any single character; an asterisk matches any sequence of characters. To search for a question mark, asterisk, or tilde character, prefix that character with a tilde (~).

The optional arguments selection-criteria-2 through selection-criteria-n have corresponding arguments cell-range-2 through cell-range-n, and have the same semantics as selection-criteria-1 and cell-range-1, respectively.