Forum Discussion
Adding numerical cells based on names in another column.
Hello!! I am working on an Excel spreadsheet where people can copy and paste in their data, then there is a column that will add up time durations and display it for them. The issue is, is that there...
If you're looking to do some selective accumulation, maybe SCAN:
=SCAN(
0,
duration,
LAMBDA(a, v,
LET(r, XMATCH(UNIQUE(shift), shift) + 1, IF(XOR(ROW(v) = r), v, a + v))
)
)