CUMIPMT(Rate,NoPaymentPeriods,PresentValue,StartPeriod,EndPeriod,Type)

Where $Rate$ is the interest rate, per peroid,
$NoPaymentPeriods$ is the number of periods over which the loan or investment is to be paid,
$PresentValue$ is the present value of loan or investment,
$StartPeriod$ is the number of the first period over which the interest is to be calculated (must be an integer between 1 and $NoPaymentPeriods$ )
$EndPeriod$ is the number of the last period over which the interest is to be calculated (must be an integer between 1 and $NoPaymentPeriods$ )
$Type$ is specifies whether the payment is made at the start or end of the period.

CUMIPMT() calculates the cumulative interest paid on a loan or an investment, between two specific periods.

Description

$StartPeriod$ should be smaller than $EndPeriod$ . Else Calci displays #NUM !error message.
If $StartPeriod$ or $EndPeriod$ is <=0, then Calci displays #NUM !error message.
If $StartPeriod$ or $EndPeriod$ is > $NoPaymentPeriods$ , then Calci displays #NUM !error message.
$Type$ value is an integer value (either 0 or 1).

0 indicates the payment is made at the end of the period; 1 indicates the payment is made at the start of the period.

Consider the following example that shows the use of COUPNUM function:

=CUMIPMT() displays  as a result.
=CUMIPMT() displays  as a result.