Index/Match to find column header and count "Pass" in column

[Gliffix101]

Hi All,

I am trying to write a formula that uses Column E data, searches the column headers of the data sheet, and counts all "Pass" values in that column. Here is my formula"

=COUNTIF(INDEX(Sales_Q1,0,MATCH('Question by Role'!E5,Sales_Q2,0)),”Pass”)

Where "Sales_Q1" is the range of the data "=Sales!$A$1:$Q$3822"
Where "Sales_Q2" is the range of the headers "=Sales!$A$1:$Q$1"
Where formula appears on the "Question by Role" sheet

I know it has to be something stupid I'm overlooking, so turning to the online community to laugh at my error and tell me where I went wrong.

Thanks!

Bill

 

[Eric W]

It appears your quote marks aren't right:

=COUNTIF(INDEX(Sales_Q1,0,MATCH('Question by Role'!E5,Sales_Q2,0)),”Pass”)

Change them to the usual marks:

=COUNTIF(INDEX(Sales_Q1,0,MATCH('Question by Role'!E5,Sales_Q2,0)),"Pass")

 

[Gliffix101]

Ugh - I knew it was going to be something stupid. I tried building the formula is MS Word before copy/paste into Excel and didn't realize the spacing and quotation marks are different. Thank you! RESOLVED!

Bill

 

[Eric W]

You're welcome!