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