SCAN returns #VALUE ERROR

Iron Contributor

SanthoshKunder_0-1700283251200.png

What I am doing wrong here ?. This formula worked until yesterday but throws #Value error now.

 

4 Replies
Are those values in cell A2:A13 still numbers, or are they TEXT? because if they are numbers, they will be aligned to right.
Yes, It is numbers. Even this doesn't work. =SCAN(0,SEQUENCE(10),LAMBDA(a,v,a+v))

@SanthoshKunder Works for me!

Screenshot 2023-11-18 at 07.00.11.png

Not sure why it is inconsistent. It worked 2 times and stopped working 3rd time for me

 

SanthoshKunder_2-1700287738256.png