Jimmy,
You can do this with the 'AND' function. Your formula should look something
like this:
=COUNT.IF(AND("Class A">500;"Class A"<4000))
"Class A" must of course be replaced bij the range of cells you want to be
counted.
Arnold Huzen
Jimmy Julianto schreef:
> OO 2.02
> Is there any function or way
> If I would like to count for class A that having value greater than 500 and
> less than 4000
> or to count for class B that having value greater than 500 and less than 4000
>
> Eg :
> Class Value
> A 1000
> B 1200
> A 5000
> B 500
>
> Any solution ?
> Thanks
>
> Regards,
> Jimmy Julianto
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
