Is it possible to use a defined array as the first argument in CHOOSE()?

Using Name manager in Formula Tab define the Array1 as {1,2,3,4,5,6,}
This ARRAY function works

=SUM(CHOOSE(Array1,A1,C1,E1,G1,I1,K1,M1))

ARRAY function should be confirmed with Ctrl+Shift+Enter Keys together.

Originally Posted by Tony Valko

Array enter the formula...

Originally Posted by kvsrinivasamurthy

Using Name manager in Formula Tab define the Array1...

Thanks for the responses, can you guys figure out why this doesn't work?

Array1 = {1,2,3}
Array2 = CHOOSE({1;2;3}, A1, C1, E1)

A1 = 5 C1 = 5 E1 = 5
A2 = 5 C2 = 5 E2 = 5

=SUMPRODUCT(CHOOSE({1;2;3},A2,C2,E2)*Array2) gives me 75
=SUMPRODUCT(CHOOSE(Array1,A2,C2,E2)*Array2) with CTRL+SHIFT+ENTER gives me 225

Originally Posted by sandy666

change from first {1;2;3} to {1,2,3} and you will get 225

Thanks! The answer I was looking for was 75 so I used that same logic and changed Array1 to use semicolons instead.

EDIT - It also works if I change everything to a comma

Sorry, I deleted text before I saw your answer
but I'm glad if it works and thanks for rep.