Thanks so much Terry I already tried this just now, and it works Thanks a lot guys
----- Original Message ----- From: "Terry" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, September 28, 2006 6:04 PM Subject: Re: [users] Need Help : Count If with several condition > It has been 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 function > > Cause I already tried about this and I still can't find the solution > > > > COUNTIF(range; criteria) > > the criteria is only limited to one criteria, and the criteria is only count all cells inside the range > > the criteria not filter each row if the class is "A" then look the value of this class wheter it is >500 and <4000 > > > > the SUMIF function is more closely to give a solution > > the criteria can filter each row if the class is "A" then look the value of this class but it only can only look into one criteria only like ">500" > > not ">500 and <4000", and the function is SUM not COUNT > > > > thanks for your help > > > > > > ----- Original Message ----- > > From: "arnold huzen" <[EMAIL PROTECTED]> > > To: <[email protected]> > > Sent: Thursday, September 28, 2006 12:46 PM > > Subject: Re: [users] 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 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] > >> > >> > >> > > > > 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 legal responsibility for the contents of this message nor > > for any damage caused by viruses. The views expressed here do not necessarily > > represent those of Dexa Group companies. > > > > > > > > > > -- > > If you're seeking, check out http://www.rci.org.au > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > 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 legal responsibility for the contents of this message nor for any damage caused by viruses. The views expressed here do not necessarily represent those of Dexa Group companies. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
