=SUM(IFERROR(IF(VLOOKUP(B2,'LC Open'!A:D,4,FALSE),#REF!,'Max points'!$A$2),0),IFERROR(IF(VLOOKUP(B2,'ADV Cup'!A:D,4,FALSE),H2,'Max points'!$B$2),0),IFERROR(IF(VLOOKUP(B2,'DPP Cup'!A:D,4,FALSE),G2,'Max points'!$C$2),0),IFERROR(IF(VLOOKUP(B2,'BW Cup'!A:D,4,FALSE),F2,'Max points'!$D$2),0),IFERROR(IF(VLOOKUP(B2,'ORAS Cup'!A:D,4,FALSE),E2,#REF!),0))