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

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

Total:

$5.00

1

2

3

4

Food Item

Cost Per

Total Cost

Item Amount

More

Less

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.