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.
