CountIf method with two constraints

[bsb2013]

Given a list with three columns: A contains a persons name, B contains their job and C contains their salary, how would u count the number of people with Job "Accounting" that also make above 50,000?

 

[GlennUK]

What version of Excel are you using? If it's Excel 2007 or higher then use the COUNTIFS function.

 

[bsb2013]

Thanks that seems to be the right path, but I actually don't know how to compare strings in Excel. EX: Countif(B:B,="Accounting") doesn't seem to work...Sorry for being such a novice

 

[bsb2013]

Also, how do you make one of the constraints, if not blank?

 

[T. Valko]

Given a list with three columns: A contains a persons name, B contains their job and C contains their salary, how would u count the number of people with Job "Accounting" that also make above 50,000?

Try one of these.

Use cells to hold the criteria:

• E2 = accounting
• F2 = 50000

For Excel versions 2007 and later:

=COUNTIFS(B2:B10,E2,C2:C10,">"&F2)

For ANY version of Excel:

=SUMPRODUCT(--(B2:B10=E2),--(C2:C10>F2))