Substracting from total if a cell reference(s) is negative

In F1 (Weeklies Remaining) I am trying to deduct any negative numbers in Row 17 from D1 so ultimately =IF(OR(B17,D17,F17,H17,J17,L17,N17)<0, I want to subtract any of these negative numbers from D1 (Weeklies)

Any ideas how I can accomplish this? Keeping in mind that if there are multiple negatives I would need the sum of all of those negatives subtracted.

Try this:

=D1+SUMIF(A1:A10,"<0")

Pete

Thanks Pete this works great!

Formula:

=if(b17<0,b17+b4,0)+if(d17<0,d17+d4,0)+if(f17<0,f17+f4,0)+if(h17<0,h17+h4,0)+if(j17<0,j17+j4,0)+if(l17<0,l17+l4,0)+if(n17<0,n17+n4,0)