ExcelBanter - Simple Array

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Simple Array (https://www.excelbanter.com/excel-discussion-misc-queries/152851-simple-array.html)

Marilyn

Simple Array

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

Peo Sjoblom

Simple Array

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?

--

Regards,

Peo Sjoblom

"Marilyn" wrote in message
...
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

All times are GMT +1. The time now is 02:16 PM.