balancing cells on criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have the following data:

ACC_DAT DIM1 DIM2 DIM3 DIM5 DIM7 JR_NR MONTH REC_AMOUNT BALANCE
010507 9990 15 2000 150 AR30-390 19556 05 90.00
010507 9990 15 2000 190 AR30-390 53339 05 -30.00
010507 9990 15 2000 190 AR30-390 53397 05 -40.00
010507 9990 16 6000 100 AR30-390 53541 05 -10.00
010507 9990 16 6000 190 AR30-395 54072 05 0.01
010507 9990 16 6000 100 AR30-396 56578 05 -50.00
010507 9990 16 6000 190 AR30-396 57076 05 -10.01
010507 9990 16 6000 190 AR30-396 57185 05 60.01

I need a function in column BALANCE that looks if the REC_AMOUNT BALANCES
BASED ON DIM7 OR DIM5 OR JR_NR.

Thanks,
 
One way:

For DIM5 in column F:

H2: =SUMIF($F:$F,F2)=0

copy down as far as required.

If you literally mean "BALANCES BASED ON DIM7 OR DIM5 OR JR_NR" then

H2: =OR(SUMIF($F:$F,F2)=0,SUMIF($G:$G,G2)=0,SUMIF($I:$I,I2)=0)
 
Back
Top