Assuming a range named "Block1", this
formula will return the sum of the cells in
column 2 of Block1:

=SUM(INDEX(Block1,0,2))

and this one the sum of the cells in
row 4.

=SUM(INDEX(Block1,4,0))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Sunny_Delight" skrev i en
meddelelse .uk...
I am getting used to using named ranges but I am finding that in large
tables
I occasionally want to refer to one column or one row of the table. Is
there
any way this can be done?