SCAN Function Formula

[Vignesh Veerasamy]

Hi Gurus

I tried one sample SCAN function formula but getting output like below please let me know where am i missing the formula

 

[pecoflyer]

Please post a sample sheet. Pictures are useless to work with. Thx
BTW which is your Office and XL version ?

 

[Debaser]

It appears you do not have an up to date enough version for that formula. It appears to use the ETA SUM function which I think is still only in Insiders Beta.

 

[Vignesh Veerasamy]

sample file

 

[Debaser]

Try:

=SCAN(D6,E10#,LAMBDA(s,c,SUM(s,c)))