Count If with Index/Match formula

[Gliffix101]

Hello,

I am looking for some assistance with a formula. I found one thread that references a similar ask, but since it's dated I did not want to post any follow up questions/clarifications.

I have the following formula:

=COUNTIFS(Data!$C:$C,'Master Summary'!B13,Data!E:E,"Pass")

This formula is counting only if Column C:C equals the value in Cell B13 and any references of "Pass" in Column E:E.

I'd like to make this formula dynamic so that instead of a direct reference to "Data!E:E" I can have it find the column header (rage E1:CE1) and when it finds the header, it counts the passes in that column.

Basically, the formula should say:
1) Find B13 in Column C (this will never change)
2) Find M13 and search E1:CE1 for this value (this will identify the search column)
3) Count all values of "Pass" in the Search column

Any help would be appreciated.

Thank you,

Bill

 

[Scott R]

If I'm understanding correctly, put this as your 3rd argument:

INDEX(Data!$E:$CE, 0, MATCH([string to find], Data!$E$1:$CE$1, 0))

 

[Gliffix101]

Hi Scott,

This worked perfectly! Thank you so much.

Bill