Referencing a Column within a Named Range

[MarkM]

Let's say that the range A110 is named TEST.

Is there any way to reference the a column within the
range TEST?

e.g.,

{=Sum(if("dog" = TEST.Col(1),TEST.Col(4),0))}


TEST.Col(1) and TEST.Col(4) represent the 1st and 4th
columns in the range named TEST, respectively.

 

[Frank Kabel]

Hi
as a workaround try
=SUMIF(OFFSET(test,,,,1),"dog",OFFSET(test,,3,,1))

 

[Alan Beban]

I have no idea what your example is attempting to sum, but the following
will return the nth column of the range named "TEST":

=INDEX(TEST,0,n)

If TEST comprises more than 1 row, it must of course be array entered
(i.e., entered with Ctrl+Shft+Enter instead of just Enter).

Alan Beban