Sum of Years to be displayed on an entire column

Hi friends, I'm new to excel and I've been learning it recently.
So could somebody help me out with the problem I'm being faced with.Excel forum.JPG

If you can see the attached image is an excel sheet.
The column F contains a list of dates & years and the column I contains only years. The series goes on upto 65 rows down.
I require a formula to add the columns F & I, such that all the rows from F1 - F65 should add I1 - I65, and the output dates & years should be subsequently displayed in the column J, for the cells J1 - J65.

Now there is the addition of dates & years formula, but the problem is I have to manually enter it in each and every cell from J1 - J65 for the addition of columns F & I. So all I require is a single formula that adds all the way from F1 - F65 to I1 - I65.

Thanking You for your help.

If you are wanting to have the column go down the entire row, click in the 1st cell that has the formula. A bold box will appear around the cell with a small black square in the bottom right corner. Click on that square, while holding the mouse button down, "drag" that box down the column to the last cell needed. This will copy the formula all the way down the column until the cell you stop at.

You may want to amend your formula like this to account for the blank rows:

Formula:

Please Login or Register  to view this content.