Enhance COUNTIFS formula to search for text in a string as part of the criteria

[freeb1893]

I have this current formula:

=COUNTIFS('RAW Data 2'!$R$2:$R$10000,$BG3,'RAW Data 2'!$O$2:$O$10000,">="&(TODAY()-$BI$1))

Basically I'm counting the # of times the value in BG3 is found in range R2:R10000 and the date/time in range O2:O10000 is greater or equal to today's date minus the # of days in cell BI1

I'd like to enhance the above formula where rather than matching on $BG3 for one of my countif conditions, I'd like to search for the text string of $BG3 in range 'RAW Data 2'!$R$2:$R$10000.

I.e. if BG3 is a partial match in range R2:R10000, I'd like to still include that in my count results.

Anyone know how to enhance the above formula to search for that partial match?

 

[BrerRabbit]

For a partial match use: "*"&"BG3"&"*"

 

[freeb1893]

For a partial match use: "*"&"BG3"&"*"

thank you sir! much appreciated!