Like the ROW function, COLUMN can be used to quickly increment calculations.
Take a look at the example spreadsheet and you’ll see what I mean. In column A, we have a sales goal.
Now, let’s increment that goal into the month columns so that January’s goal is $10,000, February’s goal is $20,000, March’s is $30,000, and so on.
First, click into cell C2.
Then type this formula:
With this formula, we’ll multiply the sales goal by the column number of the specified cell minus two.
So we’ll multiply A2 by one in row C, two in row D, and so on down the line.
This first one is simple: you get the same number.
Now use the fill handle to drag the formula to the right a few cells.
As you can see, each month now has the original sales goal multiplied by the month number.
You can use this same method to iterate any calculation across columns.