How to sum the row with reference to date range

[Audit_CKGoC]

Hi! How can I sum the [sales] between the [week_beg] and [week_end] with reference to its [date_gl]?

For Instance, if the week will start at 11/7/21 and will end at 11/13/2021, I will sum the sales with [date_gl] in that date range 11/7,11/8,11/9,11/10,11/11,11/12,11/13…

Thank you!

[Steve]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

SUM()

Arithmetic sum of list items