How to Add Numbers in Excel using Different Methods

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
    
    'Add Numbers and display result
    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.

Advanced Functions used to Add Numbers

  • SUMIF(Range, Criteria) – Total the Numbers in Range based on a criteria
  • SUMIFS(Sum Range, Criteria Range, Criteria)
  • SUMPRODUCT
  • SUMSQ – Total the square of the numbers in the argument

These are mainly arithmetic functions which we might use rarely. But sometimes we end up in writing our own functions without knowing that these functions already exist.

Also Read: How to Delete Blank Rows in Excel?

Leave a Reply