How do you make formulas on Excel?

Question

I'm not talented at this crud so if you could walk me thru it step by step. I want to add different cells into one cell. In other words I want to use the add function. Show me how to format the formulas. Thank u in advance.

Answer 1

It's not that hard, when adding cells don't think of functions think of math...don't make things harder on yourself than need be. If you have any other questions email me at morath11 at yahoo and I'll attach the lesson for simple calculations and formulas.

=A1+B2+M3+C4 with this simple formula you need the equal sign but not prenthisis.

the Equal Sign prepares Excel for a function of to calculate...after that if not using a function you can merely click the first cell type in the add and then click the second cell and so on. Now the example above is for non consecutive cells, not next to each other if your adding a row that the cells are all connected type and you want the entire row or column added click the blank cell at the end and double click the backwards E icon on the standard toolbar this adds the entire row, unless there is a blank cell then it only adds below the blank cell. You can always use the =SUM(A1+B2+M3+C4) feature that's non consecutive cells or click the fx button choose sum and hold down ctrl and click on the non adjacent cells, or if they are in the same row or column click and drag your mouse thru the cells then the formula will look like this =SUM(A1:A44) . If you use the fx and the SUM feature you don't have to worry about = signs and prenthsis excel does it for you. Hope that helps.

Answer 2

1. Click the cell where you want the total of the other cells to be.
2. Type "=SUM("
3. Click the cell of the first number you want to add. The text in the one cell should be something like "=SUM(A1" or "=SUM(Q14".
4. Type a comma, and then click the next cell you want to add.
5. Keep doing this till you click all the cells. Should look 6. something like this : "=SUM(A1,B5,G3,H4,C2" Add a closing parenthesis ")".
6. Press enter and the cell will display the sum. If you change any of the original cells the sum will change by itself.



Another way to do this is just type in the names of the cells like instead of clicking them.
If all your cells are in a row or column you can do something like this: "=SUM(B1:B12)" adds cells B1 thru B12.
"=SUM(C3:H3)" adds cells C3 through H3.
And if you type "=SUM(C3:H12)" it will add up all the cells in a big rectangle with the top left corner at C3 and the bottom right at H12.

Answer 3

Suppose you have the following info:

a1=10
b1=20
c1=30

and you want to add them and put the answer into d1.

You can enter =a1+b1+c1 into cell d1 or you can enter =sum(a1:c1) in cell d1.

Have a look at the formula builder.

Answer 4

Choose the cell you want the result in.

In your toolbars press that backwords looking roman E (Autosum).

Drag the top of the box to cover the cells you desire.

Press enter.

That's it.

Answer 5

dude.. Just visit this site www.ExcelGoodies.Com and try to take up one of their basic excel training packages..

You will probably learn everything in just 1-2 hrs instantly..

worth giving them a try.. all the best..