79460037

Date: 2025-02-22 17:58:56
Score: 1.5
Natty:
Report link

Both ROW and OFFSET are volatile functions. This formula uses neither, and you only need to declare the variables "a" and "b".

=LET(
    a, A1:A30,
    b, B1:B30,
    SCAN(0, SEQUENCE(ROWS(a)), LAMBDA(acc,v, IF(INDEX(b,v), INDEX(a,v) + acc, 0)))
)

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Bam