Reply to thread

Message: [QUOTE="Matt Stephans, post: 3091723"] Sure: Date Buy-in Finish Payout Payout (Buy-in) Net 1-Oct $11 1 $39 3.55 $39 1-Oct $11 0 ($11) (1.00) $28 2-Oct $11 1 $39 3.55 $67 2-Oct $11 0 ($11) (1.00) $56 3-Oct $11 1 $39 3.55 $95 First 3 columns are entered, 4th is an if statement based on the 3rd column. The 5th is the 4th divided by the 2nd, and the 6th is SUM(D$2:Dx) where x is the row of the cell. Now the 7th row is blank, but when I enter the first three columns of the 7th row, the 4th and 5th cells get filled automatically, but the 6th doesn't. I know about the IF trick, but these cells are blank. I didn't even know that there was a way for cells to pull a formula from a cell above them, but this does. I can email the sheet if it would help. Thanks for any assistance. [/QUOTE]