Incomplete IF() e.g.: different array evaluation depending on interim/final RequestForExplanation

[sokol92]

Array formula

{=IF(A22:A35<10;A22:A35;SUM(A22:A35))}

returns an array:

1;2;3;4;5;6;7;8;9;105;105;105;105;105

Average is 40,71428571…

The same in Excel.