If I have 3 rows in col. A , with a formula in B3 "=A3+B1"

A B C D E F G H I J1. 75 20

2. 50

3. 30 50

...and I add amount in B1 as 20, the result is going to be 50. NOW, I want to copy the same formula in B3 to the rest of the columns...C3,D3,E3, etc. BUT I don't want the total to show "50" in all the colums until I fill in the cells C1,D1,E1,F1, etc. Thanks!

Hi It's not clear what you want C3,D3,E3 to produce. If you want C3 to be

A3+C1 and D3 to be A3+D1 then your formula in B3 should be=if(B1<>"",$A$3+B1,"")

And then copy it across.

If that's not what you are looking for it would be helpful if you posted more data and highlighting what the inputs and results are.

Ask Your Question

Weekly Poll

Do you wish your email had an "undo send" feature?

Discuss in The Lounge

Poll History