I'm trying to extend a formula that creates a column in the middle of a sheet depending on what month it is (so if its november the formula creates a new column after october and heads it "over due amount" - I need help with adding a sum formula tothis new column (e.g: =SUM(AX3+AV3+AT3+AQ3+AN3+AL3+AJ3)) the difficulty is that the formula starts with the current month e.g November for this month, but december next month) and only sums every 2nd cell back to April. Once the formula is added it needs to be autofilled to all the rows in that column uptill the data finishes...can anyone help