LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Google Sheets Formulas

ADD Function in Google Sheets: Explained

In this article, you will learn how to use the ADD formula in Google Sheets.

What is the ADD formula in Google Sheets?

In Google Sheets, the ADD function allows you to add together two values. Note that the ADD function takes only two values as arguments and doesn‘t take an array or range as input.

Save hours formatting your next financial spreadsheet!
100+ templates, all free to use.
Free Spreadsheet Templates

How do you use the ADD function in Google Sheets?

Here is the syntax for the ADD function:

=ADD(value1, value2)

value1 and value2 are the cell references or manually input values you want to sum up.

For example, if you want to add 1 and 2, you can use the following formula:

=ADD(1, 2)

As another example, to add the values in cells A1 and B1, you would use the following formula:

=ADD(B4, C4)

You can see the two examples above in the following screenshot.

ADD Function in Google Sheets: Explained
How to use the ADD formula in Google Sheets

Learn how LiveFlow can save you hours a month on financial reporting!
Just 30 minutes can change the way your business operates forever.
Book a Demo

What is the alternative to the ADD function in Google Sheets?

You can use a plus sign “+” as an operator for addition in Google Sheets. For instance, if you want to add 1 and 2, you can insert the following formula in a cell:

=1+2

A cell reference can be used in addition. For example, if you want to add 1 in cell B1 and 2 in cell C1, the formula would be as follows:

=B1+C1

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: [email protected]

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.