DC wrote:
[...]
This seems to work:
=IF(ISERROR(SEARCH("4k",Hosts!$E10)),0,Hosts!$E13) +

IF(ISERROR(SEARCH("4k",Hosts!$F10)),0,Hosts!$F13)+

IF(ISERROR(SEARCH("4k",Hosts!$G10)),0,Hosts!$G13)+

IF(ISERROR(SEARCH("4k",Hosts!$H10)),0,Hosts!$H13)+

IF(ISERROR(SEARCH("4k",Hosts!$I10)),0,Hosts!$I13)+

IF(ISERROR(SEARCH("4k",Hosts!$J10)),0,Hosts!$J13)+

IF(ISERROR(SEARCH("4k",Hosts!$K10)),0,Hosts!$K13)+

IF(ISERROR(SEARCH("4k",Hosts!$L10)),0,Hosts!$L13)


=SUMIF(Hosts!$E$10:$L$10,"4k*",Hosts!$F$13:$L$13)