Forum Discussion
Solved
Accumulated sum - problems with sumif()
Hi, I've a "basic" problem: Y try to create a matrix of accumulated sum having the individual values in A1:J1. My proposal: =SUMIF(SEQUENCE(,10),"<="&SEQUENCE(,10),A1:J1) The proposal is runni...
The first and third argument of SUMIF must be ranges. They cannot be expressions that return an array of values.
If you have Microsoft 365, you may be able to use
=SCAN(0, A1:J1, SUM)
The first and third argument of SUMIF must be ranges. They cannot be expressions that return an array of values.
If you have Microsoft 365, you may be able to use
=SCAN(0, A1:J1, SUM)
Wonderful solution - thank you