help with formula that excludes two columns in formula

I trade the futures market and I decided to add two columns to my xls sheet where I contribute and draw funds.

The "U" column keeps track of the "monthly" profits but with adding these columns ("R" and "S") its adding/subtracting to/from my monthly profits (column "U").

I need help in eliminating columns R and S from column U.

Thanks.

Bruce

Hello InvGrp2,

I don't see a problem, as long as you enter any amounts in Column S as negative. If this is not what you want, could you show us what your desired outcome in Column U should be?

Regards.

you have this in T7 =IF(J7>0,Q7+P7+R7+S7+T6,T6) And T7 is used in U7 so
if you don't want R and S in U then wouldn't you simply change it to this in T7? =IF(J7>0,Q7+P7+T6,T6)

last thought on this for now, can you just add -(R7+S7) to the end of the formula in U7?
like this...
=IF($J7>0,$T7-LOOKUP(EOMONTH(DATE(YEAR($C$7),MONTH($C7),1),-1),$C$6:$C$850,$T$6:$T$850)-(R7+S7),"")
seems to work to remove the influence of S21 when dragged down.

If I understand it correctly:
With specific date, i.e, 1/26/2018 in row 10, you would like to:
Step 1) Take current Ending Balance ($10,565.15) , subtract to beginning balance of month (ending balance of previous month Dec of previous year, equals $10,000)
Step 2) Then subtract to running column R & S of the month (jan)

If I was correct, my solution is:
Step 1)
T10-LOOKUP(C10-DAY(C10),$C$6:$C$21,$T$6:$T$21)
in which, C10-DAY(C10) returns last day of previous month
Step 2)
SUMPRODUCT(($C$6:C10-DAY($C$6:C10)=C10-DAY(C10))*$R$6:S10)
to sunning sum R+S column under month condition

Then, Step 1 -step 2:
In S10

Please Login or Register  to view this content.

Copy up and down wards

The formula provided by "bebo" worked great.

=T10-LOOKUP(C10-DAY(C10),$C$6:$C$21,$T$6:$T$21)-SUMPRODUCT(($C$6:C10-DAY($C$6:C10)=C10-DAY(C10))*$R$6:S10)

The only modification I made to it was to extend the last row ($C$21 to $C$200 and $T$21 to $T$200).

Thanks again and this forum has been very helpful to me.