C
c_schear
Heres kinda how my spreadsheet looks:
Code
-------------------
A B C D
1. Disc Cost Adj Result
2. Sample1 $1.00 -1 -$1.00
3. Sample2 $5.00 -5 -$25.00
4. Sample3 $1.00 -1 -$1.00
5.
6. Sample1 $1.00 -1 -$1.00
7. Sample1 $1.00 -1 -$1.00
8.
-------------------
What I need is all the cells in row "D" to multiply C*B (easy), but i
there is nothing in C, then I need it to sum up the values in D (from
above it to the next break in numbers). So D5 would = -$27.00, and D
would = -$2.00. This is what I have come up with so far (D5):
Code
Code
-------------------
A B C D
1. Disc Cost Adj Result
2. Sample1 $1.00 -1 -$1.00
3. Sample2 $5.00 -5 -$25.00
4. Sample3 $1.00 -1 -$1.00
5.
6. Sample1 $1.00 -1 -$1.00
7. Sample1 $1.00 -1 -$1.00
8.
-------------------
What I need is all the cells in row "D" to multiply C*B (easy), but i
there is nothing in C, then I need it to sum up the values in D (from
above it to the next break in numbers). So D5 would = -$27.00, and D
would = -$2.00. This is what I have come up with so far (D5):
Code