How To Use ADD()


Returns the sum of two numbers. Equivalent to the `+` operator.

Common questions about the ADD Formula:
- What does the ADD Formula do?
- What arguments does the ADD Formula take?
- How do I nest the ADD Formula in other formulas?

How the ADD Formula can be used appropriately:
- Add numbers, to calculate the sum
- Add two or more ranges, to calculate the sum of all the values in the range
- Add an entire column or row, to calculate the total sum of all the values in that column or row

How the ADD Formula can be commonly mistyped:
- Forgetting to include a range argument when the multiple range option is used
- Not enclosing the ranges within quotes
- Not including brackets around the ranges
- Not combining ranges using semicolons or commas

Common ways the ADD Formula is used inappropriately:
- Using it to subtract values rather than add
- Not using the multiple range option when adding multiple ranges
- Using the ADD formula on non-numerical values, such as words and dates

Common pitfalls when using the ADD Formula:
- Forgetting to include all the arguments in the formula
- Not specifying the ranges properly
- Nesting the formula incorrectly

Common mistakes when using the ADD Formula:
- Including invalid arguments
- Not using absolute references when necessary
- Mixing up ranges that are not intended to be added

Common misconceptions people might have with the ADD Formula:
- Thinking that it can be used to multiply values 
- Thinking that it can only be used to add two values 
- Thinking that it is only used to add numbers and not ranges

How To Actually Use ADD() in Sheets

ADD(value1, value2)

0Better Sheets Tutorials

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Find more formulas here at Better Sheets.

Learn more about the ADD() formula:

Add, Subtract, Multiply, & Divide

Learn basic operator functions in a Google spreadsheet. If viewing in full screen mode, select the HD quality option. More videos can be found on