Hello
I have 30 columns with this formula =A1-SUM(A2:A27) WOuld like to convert
this into an array formula. this is my formula ={A1:D1-SUM(A2:D27)} then
control+shift+enter but the results are wrong (the sample only cover 4
columns)
what's wrong? Thanks