formula add value in 3 column

S

siza_05

how do i do if i want any value in column A and column B was add..and
the result is in Column C
this is what i mean..

Column A + Column B = Column C
or more easier to understand , A+B=C

it doesnt matter which cell/row/range that value located but still in
column A or B...and the result in column C

hope understand

thanks in advance!
 
N

Nigel

Is it simply a formula to add column A and column B?

Then put in column C the following

=An + Bn

where n = row number

But I am sure that is not what you are asking?
 
S

siza_05

Is it simply a formula to add column A and column B?

Then put in column C the following

   =An + Bn

where n = row number

But I am sure that is not what you are asking?

--

Regards,
Nigel
[email protected]










- Show quoted text -
Click to expand...

yup..what i actually mean is for one sheet...did i need to write a
formula for each cell in one sheet?
what i'm trying to do is ..when i key in the number in column A
(cell), its must be automatic add with value in column B(cell) and
display in column C(cell)

it must be work only on number not character or capital letters or
whatever else except number..i try to record macro with i highlight
whole column A, column B and column C ...with formula A+B=C but it
only function on fisrt cell..i want the whole cell have the formula..

thanks! hope understand!
 
Top