can i use COUNTIF with 2 conditions in excel 2000

J

jahangir

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
 
K

Khoshravan

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.
 
Top