adding columns in 2-d array

[ACLrecon]

I have a 2-d array named TEST. Is there a way of adding the contents
of a specific column of that array; e.g., a formula along the lines
of:

=SUM(TEST(1st column))

without using absolute cell references?

Thanks.

 

[Peo Sjoblom]

Try

=SUM(INDEX(TEST,,1))

--


Regards,


Peo Sjoblom