If you need this functionality, use the SUMPRODUCT function. 1. However, when the range and sum_range arguments in the SUMIF function do not contain the same number of cells, worksheet recalculation may take longer than expected.. Sumif with Date Criteria. This means you can't use other functions like YEAR on the criteria range, since the result is an array. The order of arguments is different between the SUMIFS and SUMIF functions. 1. This Excel tutorial explains how to use the Excel SUMIF function with syntax and examples. For formulas to show results, select them, press F2, and then press Enter. Like all Excel functions, though, you have to do a little bit of the work as well. SUMIF and SUMIFS can handle ranges, but not arrays. You can also use the SUMIF function in Excel to sum cells based on dates that meet specific criteria. The basic syntax for the SUMIF function in Excel is: SUMIF(range, criteria, [sum_range]) The Excel SUMIF function returns the sum of cells that meet a single condition. The SUMIF function supports … For example, the SUMIF function below sums the sales after January 20th, 2018. Examples Example 1. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. Criteria can be applied to dates, numbers, and text. The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, equal to 2000). Instead of manually going through a long list of items to identify and count similar items, you can use the SUMIF Function to do this job for you in a very short time. … So, let us go ahead and take a look at the Syntax of SUMIF Function and the actual steps to use SUMIF Function in Excel. It is a worksheet function that requires a specific syntax to yield the best results. To use SUMIF, you need to know how to express just what it is you’re looking for.