***** ADDING 2 COLUMN BASED CELLS ********

[excelfor1]

I would like to add tow columns and update the result on the first coulmn. How do I go about doing this?

Example:

column A has 10 elements.(A1-A10)
Column B has 1 element.(B1)

How do I use a formula so that I get A1+B1 in A1, A2+B1 in A2 and so on..

Thnx,
Giri.

 

[Smitty]

Welcome to the Board!

A1+B1 in A1

You don't without creating a circular reference.

Why not just use column C? =A1+$B$1

Hope that helps,

Smitty