Sumproduct #value error with more than two search terms

[TMCINNIS]

This formula works fine when I have two search terms. But when I add a third search term, I get a #value error. Any help is much appreciated.

Good one:
=SUMPRODUCT(('REPORT'!$C$67:$C$100000="MICROSITE")*(MMULT(0+ISNUMBER(SEARCH({"air-conditioning","cooling"},'REPORT'!$E$67:E$100000)),{1;1})>0),'REPORT'!$F$67:F$100000)

Returns #value error
=SUMPRODUCT(('REPORT'!$C$67:$C$100000="MICROSITE")*(MMULT(0+ISNUMBER(SEARCH({"air-conditioning","cooling","heating"},'REPORT'!$E$67:E$100000)),{1;1})>0),'REPORT'!$F$67:F$100000)

Returns #value error
=SUMPRODUCT(('REPORT'!$C$67:$C$100000="MICROSITE")*(MMULT(0+ISNUMBER(SEARCH({"air-conditioning","cooling","heating" ,"heat-pump"},'REPORT'!$E$67:E$100000)),{1;1})>0),'REPORT'!$F$67:F$100000)

 

[sheetspread]

=SUMPRODUCT(('REPORT'!$C$67:$C$100000="MICROSITE")*(MMULT(0+ISNUMBER(SEARCH({"air-conditioning","cooling","heating"},'REPORT'!$E$67:E$100000)),{1;1;1})>0),'REPORT'!$F$67:F$100000)

do anything?

Not sure you need mmult and this might also work with sumifs