add cell value to another cell without circular reference

[alexandru barabas]

hello

can someone please show me how to sum cell A1 to cel B1 in cell B1?
A B A B A B
1 2 6 2 6+2 1 8+1
2 5 1 5 1+5 7 6+7
3
4


if i make enable to circular reference it will increase the value from cell B each time i make a change to any other cells

thanks

 

[SirJB7]

Hi, alexandru barabas!

First of all, consider uploading a sample file. It'd be easier to understand for people who might be able to help you.

Include indication of the input data, the attempted solution (formulas, code) and the manually written expected output data as example. Thanks.

Regards!