Sum
Sum
Formula: Sum()
Category: Math
Sum()Adds provided numbers together
or stated otherwise...
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 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
0Number 2:
00
0Sum(, ) =
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.001
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.
Practice: Show your understanding of Sum() basics
Done
Practice using Sum() in a column-based formula
Done
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.