Progressive adding of column with 0's

[tHE fLY]

Hey everyone,

i have aver a spreadsheet that's has 3 columns

column A Column B. Column C

Gross amount. Draw received. Comm received

100,000. 1,250. 11,500(%* 100,000 - 1250)

0. 1,250. 0

0. 1,250. 0

100,000. 1,250. 7,750 (%* 100,000- 1,250-1,250-1,250)


when 0 is in column A... Column C is skipped when amount is in column A then column C adds each amount from column A where 0 is in addition to amount in the same row...

please help.

Thanks!

 

[Latchmaker]

Can you post the exact formula that is in Column C Row 4 (C4) ?

 

[tHE fLY]

Latch maker.. Thanks for the reply.. I don't have on yet.. I tried to do a few nested if statements but that wouldn't work because I could have 6 months without a gross amount... I'm needing help to determine a formula that would do this.

thanks!

 

[Latchmaker]

Can you add a fourth column?

 

[tHE fLY]

Definitely

 

[tHE fLY]

If you think we can get it done.. I'm open to anything

 

[Latchmaker]

If you can add a fourth column for Accumulative Draw this would work.
<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><table class="tableizer-table">
<tr class="tableizer-firstrow"><th>Gross amount</th><th> Draw received</th><th> Comm received</th><th>Accum Draw</th></tr>
<tr><td>100000</td><td>1250</td><td>=IF(A2>0,SUM((0.1275*A2)-IF(ISTEXT(D1),SUM(B2),SUM(B2+D1)),0),0)</td><td>=IF(C2=0,IF(ISTEXT(D1),SUM(B2),SUM(B2+D1)),0)</td></tr>
<tr><td>0</td><td>1250</td><td>=IF(A3>0,SUM((0.1275*A3)-IF(ISTEXT(D2),SUM(B3),SUM(B3+D2)),0),0)</td><td>=IF(C3=0,IF(ISTEXT(D2),SUM(B3),SUM(B3+D2)),0)</td></tr>
<tr><td>0</td><td>1250</td><td>=IF(A4>0,SUM((0.1275*A4)-IF(ISTEXT(D3),SUM(B4),SUM(B4+D3)),0),0)</td><td>=IF(C4=0,IF(ISTEXT(D3),SUM(B4),SUM(B4+D3)),0)</td></tr>
<tr><td>100000</td><td>1250</td><td>=IF(A5>0,SUM((0.1275*A5)-IF(ISTEXT(D4),SUM(B5),SUM(B5+D4)),0),0)</td><td>=IF(C5=0,IF(ISTEXT(D4),SUM(B5),SUM(B5+D4)),0)</td></tr>
</table>

 

[tHE fLY]

Looks so easy.. Let me try it.. I'll write you tomorrow thanks a ton!

 

[Latchmaker]

I edited the formulas a few times so use the current formulas