The SUMIF and SUMIFS Functions
These functions are used to add numbers in a range of data based on the user-specified single criteria. These are Worksheet (WS) functions. Figure 4.1 shows various ways in which the SUMIF function can be used.
The syntax for the SUMIF function is:
SUMIF(range, criteria, [sum_range]).
The arguments of the SUMIF function are:
1. Range—The range of cells that you want to apply the criteria against.
2. Criteria—The criteria used to determine which cells to add. The criteria could be a numerical value or text. The criteria need to be enclosed it in double quotes (“”). For example, Cells B3:B6 has a list of various foods and the corresponding Cells C3:C6 has the value of each fruit. ...
Get Tips & Tricks for Excel-Based Financial Modeling, Volume I now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
