JIYIK CN >

We will show you how to use sum in VBA.

Sum function in VBA

Sum is the most commonly used function in excel. This function is very useful as we can use sum to get the total from the financial table.

We will learn how to use the sum function in VBA, assign the result to a variable, and use the sum function in single or multiple ranges. We can WorksheetFunctioneasily use the sum function using .

Let's take an example where we enter some demo data into an Excel worksheet and get the sum of that data.

Code:

# VBA
Sub sumFunction()
Dim result As Double
result = WorksheetFunction.Sum(Range("A2:A8"))
MsgBox "Total is " & result
End Sub

Output:

We can easily get the sum of a range using the sum function. If we want to get the result of the sum of two ranges, we can use the same function.

Code:

# VBA
Sub sumFunction()
Dim result As Double
result = WorksheetFunction.Sum(Range("A2:A8"), Range("B2:B8"))
MsgBox "Total is " & result
End Sub

Output:

We can get the sum of multiple ranges using the same function. We can use more than 2 ranges to get the sum and assign the resulting value to a cell in excel.

Let's take an example where we will assign the value of the result to a cell.

Code:

# VBA
Sub sumFunction()
Dim result As Double
result = WorksheetFunction.Sum(Range("A2:A8"), Range("B2:B8"))
Range("C2").value(result)
End Sub

Output: