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.
 

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

Countif, index and match 2
Countif, IF condition is met 2
Countifs formula 2
multiple conditions 8
Countif with 2 Conditions 5
COUNTIF or something else? 9
Excel does not accept text format! 0
Need help with using Month as criteria for SUM(COUNTIFS(... 3

Top