Formulas > =ADD()

How To Use ADD() Function in Google Sheets


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)

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

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

Generate a ADD() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.