can i use COUNTIF with 2 conditions in excel 2000

  • Thread starter Thread starter jahangir
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
COUNTIF or something else? 9
Excel How to count from a column if specific condition in another column is true 3
Excel Named Ranges and Conditional Format 3
Countif Conditions - Use of conditions that vary by cell value 1
Countif, index and match 2
COUNTIF function across more than 1 column 0
Countif with indirect formulas needed 0

Back
Top