formula question
Posted by viktor on September 26, 2000 5:27 PM
ok, i have this question.i have 5 columns and 5 rows a2 a3 a4 a5 a6: b2 c2 d2 e2 f2 g2,and i'm searching for a formula to calculate a sum a2+b2, a2+b3 etc and a3+b2, a3+c2 etc a2+c2 a3+c3 etc so there's a value in each cell.thank for help!
Posted by casey on September 30, 2000 11:21 PM
from what it sounds like to me, you may end up with circular references if you try it that way. it all depends on what cell you want the value to fall in. for example, if you want the value of a2+b2 to fall in a2, that would be a circular reference. otherwise, all you have to do is type the formula in the cell that you want the value in and it should work for you.
