How do I add two columns together in a works spreadsheet?

Answer by  Math68 (308)

Most spreadsheet programs use the following set-up. Click in Column C, type =, then click in column a, type +, then click in column b, and hit enter.

Answer by  DanTycoon (42)

To add values in two different cells, type the following: In the cell C1 (without quotation marks): "=A1+B1" Then, press Enter. Click back on C1, and in the bottom right corner, there should be something you can click on. Click and drag down however many rows you want.

Answer by  sreekar (22)

Ans: Select two columns and apply right click and select Merger option. Now we are able to see merger column. Ans: Apply the formula in Column b like following format Column c=Sum(Column A +Column B) Sample: Column A 2 Column B=5 Column C=SUM(column a+Column B)=sum(2+5)=7 In Column C= 7 value stored.

Answer by  worker9693 (27)

Select C1 (Column C and row 1). Click on the formula bar. Press =, then select cell A1 and select cell B1. By pressing enter key, you will get the answer in C1. By dragging the formula C1, through the Column C gives you end result.

Answer by  mary3334 (85)

In the excel spreadsheet ,type a value in A1 column and type the second value in B1 column then in the C1 column type =(A1+B1) and then press enter key.

Answer by  gigo (1706)

Just do it in the way you would do it in excel. Write a equal character, click or specify the first field of the first column, then click or specify the first field of the second column and press return.

Answer by  philg1961 (347)

Enter the value in cell A1, enter the value in cell B1 click on cell C1 and type =A1+B1 then press enter. The value in cell C1 will be the sum of value A1 plus the value of B1. As you are typing, note that the values are displayed in the bar above the spreadsheet.

Answer by  technogeek (6640)

You take the sum of column A and then take the sum of column B and then your formula would be = whatever cell the total of column a is in + whatever cell the total of column b is in.

Answer by  gigo (1706)

With works you can use the same functions like you would do in excel. You have two possibilities: 1) joining the cells with empersant: =A1&B1 2) a function call with "Join": =Join(A1;B1).