How to make calculations?

[Ken Spiker]

I want to simply add the data in cells in one column to the data in another column and show the results in a 3rd column. Column A + column B = Column C.

[VBA Noob]

Try Concatenate

http://www.bettersolutions.com/excel...A114811611.htm
or just

=A1&" "&B1

VBA Noob

[Ken Spiker]

Hmm. Don't think concatenate is the right function for what I want. Because I'm a newbie I'm probably making certain assumptions as to how Excel works that may not be true.

Suppose we're on row 1--on the C column I've entered 3 and in Column D I've entered 2. I want column E (in row 1) to say 5. I'd sorta assumed that Excel would have a rather transparent way to do this but I can't find it.

I would also want Column E to maintain a running total or balance. That's really all I need to know. Thanks for any input.

Ken

[VBA Noob]

Called Sum

Try

=C1+D1

See link to use sum and sum wizard

http://www.bettersolutions.com/excel...S342434541.htm

VBA Noob

[Ken Spiker]

Quite obvious; but where do you enter this formula? And I don't want just row 1 to do this calculation, but all rows. Would it then just be E=C+D? Seems obvious but I'm having trouble as to how to enter this as a formula on my sheet.

[VBA Noob]

but where do you enter this formula?

I assumed you want to enter in E1

Suppose we're on row 1--on the C column I've entered 3 and in Column D I've entered 2. I want column E (in row 1) to say 5.

To sum col C and D enter this in say F1 either by double clicking a cell and start typing or select the cell then type in the formula bar

Formula Bar = Link

=SUM(C:D)

If you want to see each rows formula in a cell enter this in say E1 and enter

=C1+D1

and drag down using fill handle

Fill handle link
HTH

VBA Noob

[Ken Spiker]

Thanx for your input. I will keep working on it and ought to discover more on my own, but right now I just want to know one thing:

I was able to program using individual cell #s (A1, B4, etc.) but I still don't see how you get whole columns at a time. In other words the function generator doesn't allow only letters. Obviously no one is going to program separately each row...

Thanx,

Ken

[VBA Noob]

Didn't this work

=SUM(C:D)

I was able to program using individual cell #s (A1, B4, etc.) but I still don't see how you get whole columns at a time. In other words the function generator doesn't allow only letters. Obviously no one is going to program separately each row...

VBA Noob

[Ken Spiker]

Didn't this work

=SUM(C:D)

That's right, when I put that in I get an error.