Improve Calculations Speed

I am using this formula on over 1000 rows and it is slowing down calculations.

Is there any way to make it any more efficient please?

=IF($G11=0,0,IF(SUMPRODUCT(--(ISNUMBER(MATCH(K11:X11,$C$5397:$C$5724,0))))<>14,"",SUMPRODUCT(SUMIF(Settings!$B$40:$B$334,K11:X11,Settings!$E$40:$E$334))))

I should explain what it is supposed to do:

The first IF is simply to check if there is any data.
The second IF is to check if all of the data appears in an approved list (14 cells, so if it is more or less than 14, return blank)
The second SUMPRODUCT is adding up the data against another list of results

Any advice much appreciated.