c_schear wrote...
Heres kinda how my spreadsheet looks:

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 if
there is
nothing in C, then I need it to sum up the values in D (from 1 above
it to the
next break in numbers). So D5 would = -$27.00, and D8 would = -$2.00.
. . .
...

If you want the same formulas for all cells in column D from cell D2
down, try

D2:
=IF(ISNUMBER(C2),B2*C2,SUM(INDIRECT("R"&
LOOKUP(2,1/(1-ISNUMBER(C$1:C1)),ROW(C$1:C1)+1)&"C:R[-1]C",0)))

filled down as far as needed.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=278720