The SUMIFS Excel function

Often I find myself wanting to sum numbers based on critera on another column – SUMIFS to the rescue!

http://office.microsoft.com/en-001/excel-help/sumifs-function-HA010047504.aspx

Adds the cells in a range that meet multiple criteria. For example, if you want to sum the numbers in the range A1:A20 only if the corresponding numbers in B1:B20 are greater than zero (0) and the corresponding numbers in C1:C20 are less than 10, you can use the following formula:

=SUMIFS(A1:A20, B1:B20, “>0”, C1:C20, “<10”)

IMPORTANT The order of arguments differ between the SUMIFS and SUMIF functions. In particular, the sum_range argument is the first argument in SUMIFS, but it is the third argument in SUMIF. If you are copying and editing these similar functions, make sure you put the arguments in the correct order.

Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2,
criteria2], …)

Tags: excel