Nesting COUNTIFs

[Andrew K]

In Excel 2003, is there a way to combine the functions COUNTIF(A1:A10,"Joe")
and COUNTIF(B1:B10,">5")? In other words, the array in Cols A and B has
scores from 0 to 10 for multiple trials by Joe, Bill, and Jane; I want a
count of all of Joe's scores that are over 5.

 

[Beth Melton]

You need to look into DCOUNT instead of COUNTIF Here's a link that may help:
http://office.microsoft.com/en-us/excel/HP052090491033.aspx

Also note for application specific questions you'll obtain faster answers by
posting in newsgroup dedicated to that application, such as one of the Excel
newsgroups.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs