If I have a formula
=sumif(dates,A1,column_1)
=sumif(dates,A1,column_2)
-----------------------------
=sumif(dates,A1,column_30)
Normally if the ranges were not defined then I would be able to change column_# into something like
=sumif(dates,A1,C$1:C$10)
where C is not locked, so when copying horizontally it would change the columns referenced automatically.
How would I do the same with defined names?