Sum of max consecutive frequency match with multiple columns and multiple criteria

[G00DNESS]

SUM OF MAX CONSECUTIVE FREQUENCY OF MATCH OVER MULTIPLE COLUMNS WITH MULTIPLE CRITERIA


I wish to solve for the sum of the maximum frequencies in multiple columns with multiple criteria, using a formula that will prevent errors.




IF D9="","",
SUM MAX FREQUENCY IF D9 matches 'TCH1'!$H$114:$H$469 AND 'TCH1'!$L$114:$L$469 value <>0
AND (Simultaneously Search)
SUM MAX FREQUENCY IF D9 matches 'TCH1'!$R$114:$R$469 AND 'TCH1'!$V$114:$V$469 value <>0


I need the formula to search through BOTH H114:H469 and R114:R469 to match D9 and return the sum of the largest number of frequencies that D9 matched in Col H and R and the numeric value in Col L and V is not equal to 0


D9 is a formula-driven value (Name) that will appear as a multiple occurrence in Columns H114:H469 and in R114:R469.
The numeric values in Columns L114:L469 and V114:V469 are formula-driven as well.




Thanks in advance for any/all assistance!