The Excel SUM function calculates total of a set of numbers i.e. ranges separated.

Excel ACCRINT Function Syntax

Below is the syntax of the ACCRINT function:

=SUM( number1,[number2],... )

where:

• number – are numbers (integers, doubles, currency). These cannot be strings i.e. text

Examples

=SUM( 1, 2 ,3)
'Result
6

Assuming table below:

Summing a single range:

=SUM( A2:A6 )
'Result
15

Summing multiple ranges:

=SUM( A2:A6, B2:B6 )
'Result
15