• 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.

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.

Also Read: Name Numerology Calculator - Lucky Number from Birthday - Excel App