COUNTIFS w/Wildcards

[DynamicsOf3]

I have data in one sheet where the headings and data looks like:

ID	NAME	FACTION	QUALITY	TYPE	LEVEL	MIGHT	ROW 1	ROW 2	ROW 3	ROW 4	ROW 5
496833504	Miraculous Throne of Atlas +18	fey	6	chair	18	180015000	173% Attack	357% Load	523% Attack	699% Attack	905% Load

<tbody>
</tbody>

Currently there are 1K+ lines of data with more being added every day. In Headings Row 1 through Row 5 could be 1 of 125 different values (Attack, Load, etc). On another sheet I want to extrapolate the effects to columns where the effect is the heading. The two issues I'm having is ignoring the percentage and some effects are similar (Attack, Attack Debuff)

I want to write a formula that will look at Column H (Row 1) through Column L (Row 5) line-by-line and (with this sample line) 3 under Attack, 0 under Attack Debuff and 2 under Load. I know I can use COUNTIFS(TR.$H2:$L2;".*Attack") under the Attack Column and COUNTIFS(TR.$H2:$L2;".*Attack Debuff") under the Attack Debuff column and get the results I'm looking for.

Although I could do this under all 125 columns (fairly quickly), is there a better way to achieve these results where I could use a row/column reference rather than the text reference. For reference, Attack is in H1 while Attack Debuff is in I1.

 

[RoryA]

Welcome to the forum!

Sure:
= COUNTIFS(TR.$H2:$L2;".*"&$h$1)
For example

 

[AlphaFrog]

Try something like

COUNTIFS(TR.$H2:$L2;".*"&H1)

 

[DynamicsOf3]

Thanks for both replies, that did the trick.