Forum Discussion
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 running if I use a cell reference for the first argument, but If I use the above proposal, the response is a #Value error. Maybe there is a simple solution or anybody have a complete different solution.
Thanks for your comments
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)
2 Replies
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
