Share via

Excel - Array formulas - #NAME?

Anonymous
2017-02-09T19:38:37+00:00

I'm trying to complete a really simple array formula in excel....

I pre selected the output cells, typed "=array(A2:C4+E2:G4) then control, shift and enter but #NAME? appears in the cells.

do I need to change any excel setting in order to get this to work?

when I begin to type "=array" - the word "array" does not appear

please help!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2017-02-09T19:53:38+00:00

Hi,

You're getting a #NAME! error because there's no function in Excel called 'Array' If you want to display the sum of those cells in an array you can do this. Select a cell then drag down to select 3 empty cells and then type this

=A2:A4+E2:E4

Now to enter this you must press and hold down the CTRL + Shift key and then tap ENTER.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-02-09T19:57:02+00:00

    It is an Array formula but there is no ARRAY function

    Type in  =(A2:C4+E2:G4) then to enter it  with  Ctrl + Shift + Enter keys

    Gord

    Was this answer helpful?

    0 comments