SUMIF function

 

The Klipfolio SUMIF function allows you to sum the values in a range that meet a certain condition.

The syntax for the SUMIF function is:

SUMIF( condition , sum range )

Parameters

condition The condition that defines which cells will be added. number vector
sum range The range of cells you want evaluated by the condition. number vector

SUMIF example

Let's look at a SUMIF function example.

 

A

B

1 4 100
2 4.5 150
3 5 200
4 5.5 250
5 6 300

The following example is based on the above text from an Excel spreadsheet:

SUMIF ( A:A <= 5 ) , B:B ) 

-> [450]

Related links: