Hi, Jimmy.
I shouldn't reply to myself but I've had time to test this and working
with it has refreshed my memory.
I believe this is a sound method to achieve what you want.
Terry wrote:
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: <users@openoffice.org>
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]
