Simple Array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
What are you trying to do,assume that SUM(A2:D27) = 200

A1:D1 holds 100, 100, 100 and 100

what is your expected result?
 
Back
Top