Identifying range within a range for SUMIFS

[crocco]

Hi,

I have several named ranges which are blocks of 12 columns. How can I identify individual columns within the named ranges for use in a SUMIFS? The key thing is the named range is the starting point (as there are several exact sized ranges but with different names) and then individual columns are identified for use in SUMIFS.

Thanks!

 

[Marcelo Branco]

To get all rows of, say, column 2 of a named range(Range1) try

INDEX(Range1,0,2)

M.