The CF_SumByRow function returns the sum of cash flows of each row. It is designed to combine the spilled outputs produced by JS and JL when these functions are used with a non-zero cash_flow value.
One or more yearly cash-flow arrays. Each argument may be a spilled vector, or a two-dimensional range where each column represents one cash-flow series.
Example
Result
CF_SumByRow(A2#, B2#)
Returns a spilled yearly vector equal to A2# plus B2#, year by year.
CF_SumByRow(A2:C50)
Treats each column of the range as one cash-flow series and returns the row-by-row sum.
Combines yearly cash flows coming from different actuarial functions into one single output vector.
Notes
Description
Return shape
The function returns a spilled vector.
Different lengths
If the supplied vectors do not all have the same length, missing years in the shorter vectors are treated as zero.
Blank cells
Blank and missing cells inside a range are ignored.
Typical use
This helper is useful for portfolio totals, plan totals, or any worksheet where several member-level cash-flow vectors must be aggregated before further analysis.