Hi Guys,

I would like to know a formula to add up alternate columns in excel.
I have attached the sample of the file I will be using.

Please note:
1) i need the totals of "Successful" columns in column J.
2) I need the totals of "Total" columns in column K.
3) I will need a self updating formula or something which wont need me to change the formula as and when i add columns after Column I. As this is a daily updated sheet, I will add two columns everyday and so the totals should updated automatically.

Please help.

Sample.xls