Edit Formula to show between two numbers

**Risels7** · 12-20-2012, 09:09 AM

I have a Formula that works out when Data is less then... I just need it edited to show between or equal to.

Example... Between or equal to 10-20

Here is the code I have

=SUMPRODUCT(--(L2:L14654<=10),--(T2:T14654>U2:U14654))

Thanks

**benishiryo** · 12-20-2012, 09:17 AM

hi again Risels7, try
=SUMPRODUCT(--(L2:L14654>=10),--(L2:L14654<=20),--(T2:T14654>U2:U14654))

**Risels7** · 12-20-2012, 05:19 PM

Awesome.

Thanks, your the man benishiryo!

Now how would i go about adding " (F2:F14654=AS2) " in with that code

**benishiryo** · 12-20-2012, 08:39 PM

no problem. you should try to play around with it. adding it just requires a comma & 2 negation:
=SUMPRODUCT(--(L2:L14654>=10),--(L2:L14654<=20),--(T2:T14654>U2:U14654),--(F2:F14654=AS2))