How to Add 2 Cells in Google Sheets: Simple Formula for Fast Sums

I still remember my first spreadsheet in 1998—just numbers staring back at me. Today, adding two cells in Google Sheets takes one simple formula and about 10 seconds of your time.

No fancy tools, no special permissions. Just type =A1+B1 in any cell and hit enter. The result appears instantly, and you can drag that formula down a column to add hundreds of pairs in a flash.

This is the foundation of every spreadsheet I’ve built since helping my dad track scrap yard parts. It works for budgets, inventory, or even tracking my 23 vintage ThinkPads.

Works every time, on any device. Let’s get those numbers adding up.

What Youll Need

Instructions

Here’s the process I follow to get accurate sums without any guesswork.

Start by opening your Google Sheets document and identifying the two cells you want to add. I always make sure both cells contain numerical values—text or blank cells will cause the formula to return an error. Look for the cell references in the top-left corners, like A1 or B5.

If either cell contains text, dates, or is empty, the addition won’t work. Double-check that both cells have valid numbers. You’ll see the values displayed in the cells themselves, and the formula bar at the top will confirm the content when you click on them.

Click on the cell where you want the sum to appear. This is where the result of your addition will be displayed. I prefer placing it just below or to the right of the cells I’m adding, but it can be anywhere in the sheet—even on a different tab.

Just ensure the target cell is empty before entering the formula. If there’s existing content, clear it first to avoid overwriting data accidentally.

In the target cell, type the equals sign = to start the formula. This tells Google Sheets you’re entering a calculation. Then, type the cell reference of the first cell, followed by the plus sign +, and then the reference of the second cell. For example, to add cells A1 and B1, you’d type =A1+B1.

Press Enter after typing the formula. The result will appear instantly in the target cell. You’ll see the sum of the two numbers, and the formula bar will show the formula you entered.

Check the result to ensure it’s correct. If the sum looks off, click the target cell and review the formula in the formula bar. It’s easy to mistype a cell reference, like using A2 instead of A1, which would pull the wrong value.

If you need to adjust, simply edit the formula directly in the formula bar or the cell itself. Google Sheets updates the result automatically as you make changes.

If you need to add pairs of cells in a column or row, click the target cell with your result. Then, hover over the small square in the bottom-right corner of the cell until your cursor turns into a plus sign. Drag this fill handle down or across to copy the formula to other cells.

Google Sheets will automatically adjust the cell references in the formula as you drag. For example, if you drag =A1+B1 down one row, it becomes =A2+B2. Verify the first few results to ensure the pattern is correct.

Tips and Common Mistakes

Small details make the difference between a correct sum and a frustrating error.

Cell Content Check: In Step 1, always verify both cells contain numbers only. I’ve seen text like “Total: 5” break formulas, while blank cells return zeros that throw off calculations. The formula bar at the top is your best friend for confirming what’s actually in each cell.

Formula Precision: When entering the formula in Step 3, watch for accidental spaces between operators. Typing = A1 + B1 with spaces works, but =A1+B1 without spaces is cleaner and prevents errors if you accidentally hit space twice. Press Enter immediately after typing to see the result.

Drag Verification: For Step 5, after dragging the fill handle, always check the first two copied formulas. Google Sheets sometimes jumps references incorrectly if your data has merged cells or hidden rows. I verify by clicking the new cells and reviewing the formula bar.

Target Cell Prep: Before Step 2, clear the target cell completely—even a space character can prevent the formula from working. I once spent 10 minutes troubleshooting a “formula parse error” only to find an invisible space in the cell.

Frequently Asked Questions

What’s the difference between __PROTECT_3 and PROTECT_4__?
Both give the same result, but __PROTECT_5 is more flexible. It handles ranges (e.g., PROTECT_6) and ignores text or errors, while PROTECT_7__ requires manual entry for each cell.

Adding two cells in Google Sheets is a breeze with the =SUM() or + operator. 💡 Now that you’ve mastered this basic trick, try combining multiple cells or exploring functions like AVERAGE() for more advanced calculations. Keep practicing to speed up your workflow!