answersLogoWhite

0


Best Answer

If it's a spreadsheet, write the following formula, for example, in C1:

= A1 + B1

Or better yet, type "=", click on the first cell you want to add, type "+", and click on the second cell you want to add. The advantage of this method is that you are less likely to get it wrong.

Since the cells are adjacent, you can also use the sum() function. For example, in cell C1:

= sum(A1:B1)

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you add values of a and b in column c?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

In Excel how do you add 50 to a number in each cell?

If you wanted to just change the original cells and add 50 to them, then first type 50 into a blank cell. Then copy it. Then select the cells you want to add 50 to. Go to Paste Special and pick the Add option. 50 will be added to all the selected cells, replacing their original values with that value plus 50. That is the simplest way.Another way to add a number to the value in each cell of a column is to insert another column. If your original values are in C2:C26 you can enter the following formula in D2 (=C2+50), then copy the formula to D3:D26.To clean up the worksheet, you have a couple of options:Hide column C and view the numbers in column D.Copy column D, then paste values into column C. This will change the values of column C to the +50 values, and also increase column D by an additional +50. When you are satisfied with your numbers in column C, delete column D and you will be back where you started, except your values in column C will be +50 from the original values.


What is a calculated column in Excel?

It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.It would be a column that contains data that has been calculated using a formula. For example, you could have some numbers in column A and some numbers in column B, and then in column C write a formula to add a value in column A to the value beside it in column B. What would be in column C is a total that has been calculated, whereas what is in A and B is raw data that has been typed directly in by the user.


How do you export a column only in Open Office Cal after counting Col A plus Col B25 percent equals Col C how to remove Col A and B but keep Col C intact with results?

I don't think you can - since the values in column C are totally dependent on the values in columns A & B. If you were to copy the formulae in column C to another spreadsheet - it wouldn't show the original results - as the new spreadsheet wouldn't have the data that created the original figures.


To add a column to the right of the last column of an existing Word table select table then?

to add a column to the right of the last column of an existing Word table select table then A. insert Columns to the Right B. insert Column C. insert Cells Column Right D. insert column 1


How do you find mean for a histogram?

You need to add all the values shown on the histogram and then divide that sum by the number of values (samples). Example: There are 5 values: A, B, C, D, E. Mean value is: (A+B+C+D+E) / 5


Can You insert a row containing a null attribute value using SQL?

You cannot do it, if the column is not null in the table. Assuming you have a table TBL with columns a, b, c insert into TBL (a, b, c) values ('AAA', null, 'BBB') Now, the value null would be stored in the database for the column 'b'


What is the LCM of A B and C?

That depends on the values of A, B and C.


What is the LCM of 7 B C?

It depends on the values of B and C but without that knowledge, it is 7*B*C.


How do you add in excel?

Method 1: Type the following in a cell "=5+5" and you will get 10 Method 2: To add to cell values "=C5+D5" (content of 5th Row Column C & D) Method 3: To add some value with a Cell value "=C5+100" (Content of 5th Row Column C will get added with 100) Hope this helps


What is adjacent range in Excel?

An adjacent column is one next to the current column, on either side. Column B is adjacent to Column A. Column A and Column C are adjacent to Column B. Column B and Column D are adjacent to Column C.


Is there a software or a website that gives random matches between 2 elements from two different lists For example LIST n 1 a-b-c LIST n 2 x-y-z The match could be ay-bz-cx?

I am not aware of any website with such a function, but it is easy to do this in Excel. Here is an example, with five rows of data. Contents of column "A": a, b, c, d, e Contents of column "B": 1, 2, 3, 4, 5 Contents of column "C": = rand() (for all five cells) Select the data in columns "B" and "C" (DON'T include column "A" in the selection), and give the command to sort by column C. This will put the items in column "B" in some random order. Since column "A" doesn't change, the assignment between columns "A" and "B" will also be random. If you want to combine the values in a single cell, put the following into cell "D1": = A1 & B1. Then copy this down.


In the cell address C4 what does C signify?

The column. The columns are labelled alphabetically, e.g. "A" is column 1, "B" is column 2, "C" is column 3 and so on. The 27th column is labelled "AA", the 28th "AB" etc.