n some time since I looked at this. The SUMPRODUCT function
> may achieve what you want, e.g.
>
> =SUMPRODUCT(A1:A26="A";B1:B26>500;B1:B26<4000)
>
>
> Jimmy Julianto wrote:
> > Dear Arnold,
> > Could you please send me the sample of the file of this functio
Need Help : Count If with several condition
> 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 c
500
Any solution ?
Thanks
Regards,
Jimmy Julianto
The contents of this e-mail may be confidential and the unauthorized use,
copying, or dissemination of it and any attachments to it, is prohibited.
Internet communications are not secure and Dexa Group companies do not,
therefore, accept