I want to count the number of values in a raw compeised between >=45 to <=50
The countif does not like 2 logic arguments
Any help I would be gratful
Jamal Hakem
I want to count the number of values in a raw compeised between >=45 to <=50
The countif does not like 2 logic arguments
Any help I would be gratful
Jamal Hakem
You could set up a variable just for keeping count.
Dim counter as integer
counter = 0
'put the If/Then statement in a loop to check the rows
If rowvalue >=45 OR rowvalue <=50 then
counter = counter + 1
End If
HTH
Hi Jamal,
=COUNTIF(A:A,">=45")-COUNTIF(A:A,">50")
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"????????" <@discussions.microsoft.com> wrote in message
news:[email protected]...
> I want to count the number of values in a raw compeised between >=45 to
<=50
> The countif does not like 2 logic arguments
> Any help I would be gratful
> Jamal Hakem
I always like to use Sumproduct. It will allow you to count mulitple
criteria, or sum mulitple critieria.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
SUMPRODUCT is useful, but is not as efficient as COUNTIF, and it cannot
handle full columns as COUNTIF can.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Bill Schanks" <[email protected]> wrote in message
news:[email protected]...
> I always like to use Sumproduct. It will allow you to count mulitple
> criteria, or sum mulitple critieria.
>
> http://www.xldynamic.com/source/xld.SUMPRODUCT.html
>
I agree ... for 1 criteria countif/sumif work very well.
The main reason I like sumproduct is because it will react to filters
and only total the filtered rows. countif/sumif don't do that.
Not of itself it doesn't, you have to add other functions. Only SUBTOTAL
reacts to filters, but that can't handle conditions.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Bill Schanks" <[email protected]> wrote in message
news:[email protected]...
> I agree ... for 1 criteria countif/sumif work very well.
>
> The main reason I like sumproduct is because it will react to filters
> and only total the filtered rows. countif/sumif don't do that.
>
Hi Bob
Thank you for your swift and nice reply
I used the hint by adding contif from 45 to 50
Thank you very much again
May I ask you another question, I did ask it some moment ago and get a nice
reply consisting in a visual basic algorithm. I want to spell a number by
written text, I got one to spell in english but I could not not convert it to
Arabic, should I use ASCI but it is not easy
Thank you very much agin
Jamal
"Bob Phillips" wrote:
> Hi Jamal,
>
> =COUNTIF(A:A,">=45")-COUNTIF(A:A,">50")
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "????????" <@discussions.microsoft.com> wrote in message
> news:[email protected]...
> > I want to count the number of values in a raw compeised between >=45 to
> <=50
> > The countif does not like 2 logic arguments
> > Any help I would be gratful
> > Jamal Hakem
>
>
>
Hi Jamal,
You may be surprised to hear that I don't know Arabic <vbg>, but it should
be straightforward. Those SpellNumber functions tend to have lists of text,
and you just need to replace those with the Arabic equivalents.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"????????" <@discussions.microsoft.com> wrote in message
news:[email protected]...
> Hi Bob
> Thank you for your swift and nice reply
> I used the hint by adding contif from 45 to 50
> Thank you very much again
> May I ask you another question, I did ask it some moment ago and get a
nice
> reply consisting in a visual basic algorithm. I want to spell a number by
> written text, I got one to spell in english but I could not not convert it
to
> Arabic, should I use ASCI but it is not easy
> Thank you very much agin
> Jamal
>
>
> "Bob Phillips" wrote:
>
> > Hi Jamal,
> >
> > =COUNTIF(A:A,">=45")-COUNTIF(A:A,">50")
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "????????" <@discussions.microsoft.com> wrote in message
> > news:[email protected]...
> > > I want to count the number of values in a raw compeised between >=45
to
> > <=50
> > > The countif does not like 2 logic arguments
> > > Any help I would be gratful
> > > Jamal Hakem
> >
> >
> >
Hi Bob
I really apologize, but I did not mean this. I just tried what you've
suggested already, but it did not work. I thought that as it exsits the bhat
function which writes in Thai characters, that it may be the same. I have
substitute the words in Arabic in that spellnumber, something is not
mathching.
I've never used paogramming in Arabic strings, since all my studies were in
English anyway one of my students is trying to help, if he succeds I'll let
you know
Thank again for your swift reply
Jamal
"Bob Phillips" wrote:
> Hi Jamal,
>
> You may be surprised to hear that I don't know Arabic <vbg>, but it should
> be straightforward. Those SpellNumber functions tend to have lists of text,
> and you just need to replace those with the Arabic equivalents.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "????????" <@discussions.microsoft.com> wrote in message
> news:[email protected]...
> > Hi Bob
> > Thank you for your swift and nice reply
> > I used the hint by adding contif from 45 to 50
> > Thank you very much again
> > May I ask you another question, I did ask it some moment ago and get a
> nice
> > reply consisting in a visual basic algorithm. I want to spell a number by
> > written text, I got one to spell in english but I could not not convert it
> to
> > Arabic, should I use ASCI but it is not easy
> > Thank you very much agin
> > Jamal
> >
> >
> > "Bob Phillips" wrote:
> >
> > > Hi Jamal,
> > >
> > > =COUNTIF(A:A,">=45")-COUNTIF(A:A,">50")
> > >
> > > --
> > > HTH
> > >
> > > Bob Phillips
> > >
> > > (remove nothere from email address if mailing direct)
> > >
> > > "????????" <@discussions.microsoft.com> wrote in message
> > > news:[email protected]...
> > > > I want to count the number of values in a raw compeised between >=45
> to
> > > <=50
> > > > The countif does not like 2 logic arguments
> > > > Any help I would be gratful
> > > > Jamal Hakem
> > >
> > >
> > >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks