Or you want one total for multiple conditions criteria. Shortcut for Applying SUM Formula in Excel Instead of applying the sum formula in the normal way you can also apply the SUM Formula using a shortcut. Type out the first cell reference then a.
The SUMIF function below sums the sales after January 20th 2018.
SUMIF function will perform SUM. Sum_range Cells to add Criteria_range1 Range of cells that we want to apply criteria1 against Criteria1 Used to determine which cells to add. The DATE function in Excel accepts three arguments. Use a SUMIF statement to count the number of cells in a range that pass a given test or to sum those values in a range for which corresponding values in another or the same range meet the specified criteria.