Microsoft Excel is a very popular spreadsheet program which is easy to use and it has a lot formulas which are related to finance, statistics, logical and arithmetic etc..
Furthermore, this is very popular among those who are working in office, in the field finance, administration and management. In this post, I will demonstrate how to add two
numbers from two columns and get result into third column.
Suppose you want add numbers from columns A and B and put results into corresponding C cells.
i.e.
A1 + B1 = C1
A2 + B2 = C2
A3 + B3 = C3
A4 + B4 = C4
A5 + B5 = C5
See the steps-
Step-1-
Write = A1 + B1 in C1 cell.
Step-2-
Press enter then the numbers inside cell A1 and B1 will get added and you can see the result.
Step-3-
Stretch from corner of C1 cell to C5 then in C2, C3, C4, C5 formulas = A2 + B2, = A3 + B3, = A4 + B4 and = A2 + B2 will automatically get filled.
And you can also see the results in C2, C3, C4 and in C5.
