CountIF function with two Criterium

  • Thread starter Thread starter hiljay
  • Start date Start date
H

hiljay

Greetings -

Is there anyway to make create a COUNTIF function with two different
criterium (i.e. >100 and <=499.99, etc)?

If not, can someone direct me to a function that can assist me in
counting cells that have data with two or more criterium?

Thanks!
 
Try one of these:

Count values greater than 100 and less than or equal to 499.99:
=SUMPRODUCT((A1:A100>100)*(A1:A100<=499.99))
OR
=COUNTIF(A1:A100,">100")-COUNTIF(A1:A100,"<=499.99")

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

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

speeding up calculation: replacing array formula with databasefunction? 9
data filtering based on last two digits of large number 13
Excel Need Countifs Formula Help 0
Help with countifs 1
Countif function with two ranges, possible? 2
COUNTIF with more than 1 condition 2
Problems with count, counta and countifs 3
strings as criteria in database function DCOUNT 2

Back
Top