O'Reilly logo

Tips & Tricks for Excel-Based Financial Modeling, Volume I by M.A. Mian

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 4

Most Used Excel Functions

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required