I'm still having some problems with the syntax for nesting other functions
within an array formula.

I want to do something like:
=SUM(IF((AND($L$2:$L$10000=E5,$L$2:$L$10000<=E5+6 ))*($AL$2:$AL
$10000="166389")*(MID($A$2:$A$10000,4,1)="2"),$G$2 :$G$10000))

The nested MID function works fine, but when I try to put in the AND function
then I have problems.

Suggestions?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200508/1