Increment A2 from A1 and A2 Sum

J

jpor

I have two cells:

A1 - manual value
B1 - automatic value (formula) = B1 + A1

(error: reference circular)

Note:

I have this formula repeated in some lines:

= B2 + A2
= B3 + A3
..
 
A

ampleford

i'm not sure i understand what you're asking - the "circular reference
you're getting is because you're trying to do a calculation in B1 whic
is asking for part of it's answer in B1...


am i helping at all
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Data Validation and drop-down list using IF, AND and what else? 8
find oldest date with a condition 4
Copy Data from One sheet to Different Sheets 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Very strange behaviour of VLOOKUP in Excel 2010 4
Increment A2 from A1 and A2 Sum 5
How to get cell coordinates? 3

Top