Formula Components

Formulas and Databases

Reference

Formula Examples

add

Learn how to use the add (+) operator in Notion formulas.

The **add** (

`+`

) operator allows you to:1

number + number

2

string + string

3

β

4

add(number, number)

5

add(string, string)

When used in mathematical equations, the

`+`

operator follows the standard mathematical order of operations (PEMDAS). For more detail, see Operator Precedence.You can also use the function version,

`add()`

.1

2 + 5 // Output: 7

2

β

3

"Monkey D." + " Luffy" // Output: Monkey D. Luffy

4

β

5

add(4,7) // Output: 11

6

β

7

add("Monkey D."," Luffy") // Output: Monkey D. Luffy

If you need to work with more than two operands, the shorthand

`+`

is by far the easiest way to do it.1

4 + 3 + 6 + 9 // Output: 20

2

β

3

add(add(4,3),add(6,9)) // Output: 20

4

β

5

"King" + " of the " + "Pirates" // Output: King of the Pirates

6

β

7

add(add("King"," of the "),"Pirates") // Output: King of the Pirates

The example database below tracks a week of treasure-collecting by three pirates. The **Total** formula adds up all the treasure gathered by the three pirates collectively.

add

College Info Geek on Notion

Note how Iβve set the **number format** of each column to **U.S. Dollar.** Iβve also set each columnβs **Calculate** value to **Sum,** allowing me to see the total of all rows put together.

1

prop("Luffy") + prop("Zoro") + prop("Nami")

Instead of using hard-coded numbers, Iβve called in each property using the

`prop()`

function.β My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.

Last modified 20d ago

Copy link

On this page

Example Formulas

Working with 3 or More Operands

Example Database

View and Duplicate Database

"Total" Property Formula