| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make formula more simple --- array? | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
Linear Mode
