Examples
The following table tracks sales of different kinds of fruit in a shop:
A
B
C
1
Fruit
Amount
Variety
2
Blueberries
10
Berries
3
Raspberries
20
4
Strawberries
60
5
Lemons
Citrus
6
Limes
30
7
Oranges
40
Use SUM to add number values
SUM can be used to add any number of values, like a calculator. The following are some ways to use the SUM function:
Add numbers directly:
This formula returns 120.
Add up the values in an entire column: