PDA

View Full Version : Formula Help



jaaakez99
04-26-2010, 01:58 PM
Not sure how to describe this problem. I want a formula that updates the Cell, "Beginning Balance:Current Balance" as more rows are added with new dates and correpsonding dollar amounts. Its the cell below with the REF error, and the Cur. Bal. should be over it. I just cant make the table look quite right. Any suggestions?

Cur. Bal. 1/8/2010 1/22/2010
Beg. Bal. #REF! $ 2,000 $ 3,000

lucas
04-26-2010, 02:50 PM
Hi jaakez, we have no way of knowing what the formula is in that cell

can you clue us in?

You can attach your workbook by going advanced and scroll down till you find manage attachments.

remove any real data and show us the problem with notes.

jaaakez99
04-26-2010, 02:59 PM
not sure I did it right

jaaakez99
04-26-2010, 03:00 PM
can you see the attachment?

Bob Phillips
04-26-2010, 03:49 PM
Nope!

jaaakez99
04-27-2010, 05:14 AM
attachment should be included.

jaaakez99
04-30-2010, 10:04 AM
thanks anyway

Bob Phillips
04-30-2010, 10:10 AM
Try

=INDIRECT(ADDRESS(ROW(),$B$1))

jaaakez99
04-30-2010, 10:24 AM
WORKED, THANKS!!!!!!!!!!!!!!!!!!!!!!!