Wise Google directed me to your Array Formula post-- just what I needed today! Many thanks for the lesson. It's working gangbusters for 80% of my worksheet, but the other 20% requires a more complicated logical test in my IF statement, that seeks a value BETWEEN instead of EQUAL to the reference cell... such that:
=SUM(IF("599"<$A$27:$A$615<"651",1,0))
This logical test works against a single value, but not against an array. Any ideas if the problem is something silly, like formatting, or is this a limitation to the array formula itself? Thanks for your help!!
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
branchandroot
more complex logical tests?
Date: 2011-06-06 05:28 pm (UTC)=SUM(IF("599"<$A$27:$A$615<"651",1,0))
This logical test works against a single value, but not against an array. Any ideas if the problem is something silly, like formatting, or is this a limitation to the array formula itself? Thanks for your help!!