Hi:
I'm trying to do the following:

ColA ColB
9 SUMIFS(Data!I:I,Data!C:C,"="&ProdYear,Data!G:G,"=" &ProdLine)
10 SUMIFS(Data!J:J,Data!C:C,"="&ProdYear,Data!G:G,"=" &ProdLine)
4 SUMIFS(Data!D:D,Data!C:C,"="&ProdYear,Data!G:G,"=" &ProdLine)
1 SUMIFS(Data!A:A,Data!C:C,"="&ProdYear,Data!G:G,"=" &ProdLine)
n SUMIFS(Data!n:n,Data!C:C,"="&ProdYear,Data!G:G,"=" &ProdLine)

Notice that the column on the leftmost Data!n:n parameter directly relates
to the number in colunn A. I would like the "n:n" to be dynamic, referencing
the number in A:A to get the proper column. Something like:
Data!column(A1):column(A1).

I don't want to change the sheet over to R1C1 notation if I can avoid it...
Can you help?
Thanks!

Greg