How to apply formula in excel eg. column 1-- 4,5,6 column 2- 7,8,9 in column 3- we want sum of column 1 and 2 eg. column 3-11,13,15

Please Look into this

You could use tables to perform you calculations and then save result back to excel file.