iferror with and, less than greater than inbetween

K

kronikjb

New member
Joined
Jan 30, 2015
Messages
14
Reaction score
0
Points
0
hi,

i have a formula

=SUMPRODUCT(($C$4:$C$32600="W")*(G$5:G$32601="PICK")* (IFERROR($J$3:$J$32599-$C$7:$C$32603;2)<=2/24);G$4:G$32600)

1.how do i write the

(IFERROR($J$3:$J$32599-$C$7:$C$32603;2)<=2/24)

so it is not less than 2/24 but in in between 0,1/24 and 0,5/24(greater than 0,1 AND less than 0,5).

2. is it necesary to write <= or does it always work fine with < or >. What is the difference if you write "<" or just <?

3. is the only way with command AND or is there some other way?

..........................

i tryed the formula

=SUMPRODUCT(($C$4:$C$32600="W")*(G$5:G$32601="PICK")*(IFERROR($J$3:$J$32599-$C$7:$C$32603;2)and(>0,1/24;<0,5/24));G$4:G$32600)

it returns an error..
why doesnt this work?
 
Because it is syntactically incorrect.

Try

=SUMPRODUCT(($C$4:$C$32600="W")*(G$5:G$32601="PICK")*(IFERROR($J$3:$J$32599-$C$7:$C$32603;2)>0,1/24)* (IFERROR($J$3:$J$32599-$C$7:$C$32603;2)<0,5/24);G$4:G$32600)
 
You must log in or register to reply here.
Back
Top