Sum
Share
Explore
Sum

icon picker
Sum

⁠
⁠
⁠
Formula: Sum()
Category: Math
plus-math.svg
⁠
⁠
Sum()
Adds provided numbers together
or stated otherwise...
Hey Coda, can you add these numbers together?

Sum() has one parameter:
exposure-value (8).svg
⁠
⁠
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:
00
0
⁠
⁠

Number 2:
00
0
⁠
⁠

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

ingredients.svg
⁠
⁠
Total:
$5.00
⁠
⁠

1
2
3
4
Food Item
Cost Per
Total Cost
Item Amount
More
Less
Eggs
$5.00
$5.00
1
​
​
Milk
$3.50
$0.00
0
​
​
Butter
$3.00
$0.00
0
​
​
Central Market’s Pumpkin Spiced Cookies
$4.00
$0.00
0
​
​
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.

⁠
⁠
⁠

Done
Done
⁠


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