This is from a report that I am exporting into ExceL.
If the A or C cell has a zero value the cell is blank.....but still I need
to figure in the number in the other cell. In the following: E1,E2,andE3 are
one entry; E5 and E6 are another entry; E8 is part of another entry.......

E1: =sum(A1,-C1)
E2: =sum(E1,A2,-C2)
E3: =sum(E2,A3,-C3)
row 4 is blank
E5: =sum(E3,A5,-C5)
E6 =sum(E5,A6,-C6)
row 7 is blank
E8 =sum(E6,A8,-C8)
etc., etc., etc.,..........

Note: sometimes the entries are 2 rows and sometimes they are 20 or more
rows long. I need to continue the running balance (Column E) in spite of the
blank rows between entries. And I need to fill the formula down the E column
as there are sometimes hundreds of entries so I cannot modify each "row
formula". It would be simple if there were no blank rows...... Also, if
possible to "look pretty" I'd like the E cells in the blank rows to also look
blank. Have I given you enough?????? If you can figure this one, you are a
genius in my book!

"Max" wrote:

Post your point formulas
In E1: ?
In E2: ?
E2 is then copied down?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"teprps - ko" wrote
This works only if both the debit and credit cells contain data. However,
in
an accounting entry one row has a debit entry - leaving a blank credit
cell.
The next row might have a credit entry - leaving the debit cell blank.
Therefore, with your formula when it sees a blank cell it ignores the data
cell and the balance cell is blank. I need it to work like this:
i.e. A1 = 4, C1 = 0, E1 = 4
A2 = 6, C2 = 0, E2 = 10
A3 = 0, C3 = 1, E3 = 11
Row 4 is blank
A5 = 0, C5 = 3, E5 = 14

Any other ideas???