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 :
ClassValue
A1000
B1200
A 5000
B
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 functi
ook 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:
Sent: Thursday, September 28, 2006 12:46 PM
Subject: Re: [users]
is SUM not COUNT
thanks for your help
- Original Message -
From: "arnold huzen" <[EMAIL PROTECTED]>
To:
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'
quot;
<[EMAIL PROTECTED]>
To:
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;
Thanks so much Terry
I already tried this just now, and it works
Thanks a lot guys
- Original Message -
From: "Terry" <[EMAIL PROTECTED]>
To:
Sent: Thursday, September 28, 2006 6:04 PM
Subject: Re: [users] Need Help : Count If with several condition
> It has bee
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:
> onderwerp: Re: [us