LAMBDA: SumPeriodλ

Code

This is the code as of this writing. For the most current version, see the Gist.

/*

FUNCTION NAME: SumPeriodλ

DESCRIPTION: Returns a vector array of totals by row for values between (inclusive) dates

This was developed for budgeting where we have expenses that start, and

sometimes repeat at regular intervals.

EXAMPLE: =SumPeriodλ(daValues, daDates, daPeriodStart, daPeriodEnd)

For more on this see: https://sites.google.com/site/beyondexcel/home/excel-library/lambda-sumperiod%CE%BB

ARGS:

Values A two dimensional array of values where each column is for a specific day

Dates A one dimensional array of dates that apply to each column in Values

PeriodStart A one dimensional array of dates denoting the start of a period to total Values by

PeriodEnd A one dimensional array of dates denoting the End of a period to total Values by

Copyright: Craig Hatmaker 2022 - Anyone may use but not claim ownership or authorship

*/

SumPeriodλ = LAMBDA(

// Parameter Declarations

Values,

Dates,

PeriodStart,

PeriodEnd,

// Function starts here

LET(

// Determine # of array rows

Rows, SEQUENCE(ROWS(Values), , 0),

// Function starts here

SUMIFS(

OFFSET(Values, Rows, 0, 1),

Dates, ">=" & PeriodStart,

Dates, "<=" & PeriodEnd

)

)

);