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

The SUMIFS function syntax has the following arguments:
sum_range (required): One or more cells to sum, including numbers or names, ranges, or cell references that contain numbers. Blank and text values are ignored.
criteria_range1 (required): The first range in which to evaluate the associated criteria.
criteria1 (required): The criteria in the form of a number, expression, cell reference, or text that define which cells in the criteria_range1 argument will be added.
For example, criteria can be expressed as 32, ">32", B4, "apples", or "32."
criteria_range2, criteria2, … (Optional): Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.

for more information read this: http://office.microsoft.com/en-001/e...010047504.aspx


Regards,
SDCh