I'm sorry to have to disappoint you here, but I thought is could be as easy as this. I don't know how you could make it work.
Arnold Huzen > van: "Jimmy Julianto" <[EMAIL PROTECTED]> > datum: 2006/09/28 Thu PM 12:07:05 CEST > aan: <[email protected]> > onderwerp: Re: [users] Need Help : Count If with several condition > > 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. > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
