Count # of instances meeting criteria that aren't uniform

[gravanoc]

Is there a single-cell formula that I can use to count the number of times a value in range F5:F128 is >= to H5:F128, and also where symbols in range C5:C128 <> symbols in M5:M15?

Trying to do it with a formula & not VBA or helper columns; also prefer it to be dynamic so that it will accommodate changes to the list in column M.

Sample data:

FINALwatchlist.csv
	C	D	E	F	G	H	I	J	K	L	M
4	Symbol	LastWk	Description	Close	20WkEma	Q_Piv	Starc+	Starc-			Growth
5	AIEQ	27.35	ETF MANAGERS TRUST AI POWERED EQT ETF	27.6	29.13	30.09	30.78	30.78			RPG
6	ARKG	29.2	ARK ETF TR GENOMIC REV ETF	29.49	30.5	31.33	34.46	34.46			FDN
7	ARKK	35.74	ARK ETF TR INNOVATION ETF	37.53	38.09	38.61	45.02	45.02			CLOU
8	ARKW	47.1	ARK ETF TR NEXT GNRTN INTER ETF	49.2	49.23	48.97	59.23	59.23			IPO
9	CLOU	16.73	GLOBAL X FDS CLOUD COMPUTNG ETF	16.79	17.15	17.8	19.12	19.12			IWF
10	DIA	340.36	SPDR DOW JONES IND UT SER 1 ETF	335.98	333.18	330.37	354.73	354.73			XLK
11	EEM	39	ISHARES TRUST MSCI EMG MKT ETF	39.42	39.19	39.63	41.69	41.69			VGT
12	EFA	73.51	ISHARES TRUST MSCI EAFE ETF	74	70.64	69.96	77.05	77.05			ITB
13	EMB	84.95	ISHARES TRUST JPMORGAN USD EMG ETF	85.14	85.59	86.62	88.67	88.67			XLV
14	EMLC	24.83	VANECK ETF TRUST VANECK J. P. MORGAN EM LOCA	25.29	24.86	25.01	25.92	25.92			XLY
FINALwatchlist

 

[Fluff]

How about

=SUMPRODUCT((F5:F128<>0)*(F5:F128>=H5:H128)*(ISNA(MATCH(C5:C128,M5:M100,0))))

 

[gravanoc]

Thanks, good answer.

 

[Fluff]

You're welcome & thanks for the feedback.