View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default 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