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
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 Read More
