can i use COUNTIF with 2 conditions in excel 2000
 

respected sir,
i want to use COUNTIF with two condition in excel
(greater than 100000 but equal to 200000) i want to count the number of
entries in the specified range. please help me

can i use COUNTIF with 2 conditions in excel 2000
 

=COUNTIF(A1:A10,200000)


On Jan 29, 11:59*am, jahangir
wrote:
respected sir,
* * * * * * * * * * i want to use COUNTIF with two condition in excel
(greater than 100000 but equal to 200000) i want to count the number of
entries in the specified range. please help me

can i use COUNTIF with 2 conditions in excel 2000
 

Hi

=COUNTIF(A:A,100000)-COUNTIF(A:A,200000)

--
Regards
Roger Govier

"jahangir" wrote in message
...
respected sir,
i want to use COUNTIF with two condition in excel
(greater than 100000 but equal to 200000) i want to count the number of
entries in the specified range. please help me

can i use COUNTIF with 2 conditions in excel 2000
 

greater than 100000 but equal to 200000 is equal to 200000. Second condition
is not correct maybe you mean "less than 200000" which is more logical.

"jahangir" wrote:

respected sir,
i want to use COUNTIF with two condition in excel
(greater than 100000 but equal to 200000) i want to count the number of
entries in the specified range. please help me

can i use COUNTIF with 2 conditions in excel 2000
 

Hi,

I suspect you mean greater than 100,000 and less then or equal to 200,000?

In 2000:

=SUMPRODUCT(--(A1:A99100000),--(A1:A99<=200000))


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"jahangir" wrote:

respected sir,
i want to use COUNTIF with two condition in excel
(greater than 100000 but equal to 200000) i want to count the number of
entries in the specified range. please help me