## How to Add in Excel?

Open Excel Workbook and follow the steps mentioned below.

1. Select Range of Cells that you want Sum in Excel sheet & Click ‘AutoSum’ in Home Menu Right hand side end.
2. Type ‘=1+2’ in Excel Sheet and hit Enter. It will answer as 3
3. Type ‘=Sum(1,2,3)’ , press Enter to get result 6

Add Numbers Using Reference to Cells

1. Type in Cell A1 ‘=B1+B2+B3’, it will add the numbers in cells B1,B2,B3
2. Type in Cell A1 ‘=SUM(B1,B2,B3)’, it will add the numbers in cells B1,B2,B3
3. Add Numbers Using Reference to another Worksheet: Type in Sheet1 Cell A1 ‘=Sheet2!A1+Sheet2!A2+Sheet2!A3’

These are the different possible methods that can be used to sum or total in Excel Sheet.

Read Also: How To Compare Two Excel Files?

## How to Add Numbers in Excel Macro VBA Code

To add numbers in Excel VBA macro, the operator ‘+’ has to be used directly.

```Sub Add_Numbers_In_Excel()
'Declare variables used in program
Dim i As Integer, j As Integer, k As Integer

'Get a value from Excel Sheet
i = VBA.Val(ThisWorkbook.Sheets(1).Cells(1, 1))
j = 2

k = i + j
MsgBox "Addition of Numbers Result is: " & k
End Sub```

This sample will just work well. But in case if there are lot of numbers that you want to sum, then fetch the numbers from worksheet and add them inside a loop.