Sum

Explore

Gallery

Sum

$icon picker$
Sum

⁠

Formula: Sum()

Category: Math

⁠

Sum()

Adds provided numbers together

or stated otherwise...

Hey Coda, can you add these numbers together?

Sum() has one parameter:

⁠

Value

Sum(Value)

A number or list of numbers you'd like to add

⁠

This lesson’s “Learn” section will be relatively brief because Sum() is less “coding” and more just arithmetic. As such, this (and its related formulas in

The Mentions (Math)⁠

section) will rarely be used as the foundation of a string of formulas; rather, this will be snuck in or tacked on.

So, how what does this formula look like in action?! Play with the sliders below to see how the parameters work within Sum().

Number 1:

⁠

Number 2:

⁠

Sum(

0

⁠

0

⁠

) =

0

⁠

Now that you’ve seen the formula in action, let’s see how it can be used when working with money. Interact with the more and less buttons to see how the formula tallies the total cost of this week’s groceries. It’s helpful to keep in mind that you can also calculate the sum of a list by placing it before the formula. Check it out in the formula below!

Anonymous User's Grocery List

⁠

Total:

$5.00

⁠

Food Item

Cost Per

Total Cost

Item Amount

Less

Eggs

$5.00

Milk

$3.50

$0.00

Butter

$3.00

$0.00

Central Market’s Pumpkin Spiced Cookies

$4.00

$0.00

There are no rows in this table

⁠

So, where will this formula be most useful? Most find themselves using Sum() in dashboards and tables that deal with money, or in situations with other statistic or numeric needs.

⁠

Practice: Show your understanding of Sum() basics

Done

Practice using Sum() in a column-based formula

Done

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.