Count values with multiple criteria

[crayhons]

Hi all,

I'm trying to formulate code that goes through a column and counts instances where the following three conditions are met:

• age < 40
• salary >= 10,000
• salary <= 19,999

Thanks.

[Melvinrobb]

Are you wanting code, or a formula?
you also mention you want to look at A column. would the Age and Salary not be in seperate columns?
Assuming Age is in column A, and Salary is in column B, the formula below should work. You will need to change the cell references though.
=COUNTIFS($A$1:$A$100,"<40",$B$1:$B$100,">=10000",$B$1:$B$100,"<=19999")

[newdoverman]

If the ages are in column A and the salaries are in column B the following will count the records that meet your criteria:

Please Login or Register  to view this content.

Change the cell references to match your data.