Hi,
I have written an array formula that evaluates 2 criteria before
counting...here it is:
{=COUNT(IF(INDIRECT(B5&"!$D$2:$D$500")="CURRENT",I F(INDIRECT(B5&"!$E$2:$E$500")="1",INDIRECT(B5&"!$C $2:$C$500"))))}

The above forumla works perfectly.

I'm trying to use the same formula to count the same data with slightly
different criteria. On the new formula, I'd like to substitute the "CURRENT"
criteria with a number range...ie: 1=x<=30.

What syntax should I use?