{"id":695,"date":"2019-04-18T14:36:07","date_gmt":"2019-04-18T11:36:07","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=695"},"modified":"2019-04-18T14:39:04","modified_gmt":"2019-04-18T11:39:04","slug":"the-sumifs-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-sumifs-function\/","title":{"rendered":"The SUMIFS Function"},"content":{"rendered":"\n

The SUMIFS <\/b><\/span>function adds the cells that meet all its multiple criteria. Even though its logical elements, it is part of the Mathematical functions of Excel.<\/p>\n\n\n\n

We have prepared a tutorial on the SUMIFS<\/a><\/strong>function to explain it in a bit more detail.<\/p>\n\n\n\n

\n\nThe syntax of the function is the following:\n\n<\/p>\n\n\n\n

SUMIFS<\/strong>(Sum_range<\/strong>, Criteria_range1<\/strong>, Criteria1<\/strong>, [Criteria_range2<\/strong>, Criteria2<\/strong>, ..<\/strong>.]) <\/p>Sum_range<\/strong>: The cell range we want to sum.
Criteria_range1<\/strong>, Criteria_range2<\/strong>, … : Criteria_range1 is required. The rest (up to 127) are optional. They are the range of cells that have to meet certain criteria.
Criteria1<\/strong>, Criteria2<\/strong>, … : Same as above only the first is required. The rest (up to 127) are optional. You cannot enter Criteria without a Criteria_range and vice versa. They contain the criterion (expression, number, reference…) that the respective criterion_range has to meet.<\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n

If a cell in a criteria range is empty, SUMIFS considers it a zero.<\/p>\n\n\n\n

TRUE is considered 1 and FALSE 0.<\/p>\n\n\n\n

Each Criteria_range <\/strong>must be the same size and shape as Sum_range<\/strong>.<\/p>\n\n\n\n

You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.<\/p>\n\n\n\n\n

<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here are two examples of how to use the SUMIFS function:<\/strong><\/p>\n\n\n\n

In the cell H4 calculate the sum of all orders with amount greater than 40, which were placed after 2\/1\/2004.<\/p>\n\n\n\n

\n