View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
البيانات[_2_] البيانات[_2_] is offline
external usenet poster
 
Posts: 3
Default How do I use countif an array for =45<=50

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)

"????????" wrote in message
...
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)

"????????" wrote in message
...
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