Hey everyone,

I have a spreadsheet with 3 columns.. Amount, base, paid

The amount is total produced

Base-- base pay (draw)

Paid-- amount comm paid

A B C
100,000 1000 14,000-(B1)

BLANK 1000 BLANK

100,000 1000 35,000-(B2+B3)


FOR EVERY BLANK.. I am wanting to sum each 1,000, including the next 1,000 on a non-blank row and subtract from the next "paid" amount

I am having trouble coming up with the concept..

any help would be appreciated