Can anyone help with simplifying this super long Excel IF statement?

[YPerez]

=(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$F$3,$BX$1:$CA8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$C$3,$BX$1:$CA8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$G$3,$CB$1:$CE8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$D$3,$CB$1:$CE8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$H$3,$CF$1:$CI8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$E$3,$CF$1:$CI8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$L$3,$CJ$1:$CM8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$I$3,$CJ$1:$CM8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$M$3,$CN$1:$CQ8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$J$3,$CN$1:$CQ8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$N$3,$CR$1:$CU8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$K$3,$CR$1:$CU8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$O$3,$CV$1:$CY8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$O$3,$CV$1:$CY8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$P$3,$CZ$1:$DC8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$P$3,$CZ$1:$DC8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$U$3,$DH$1:$DK8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$R$3,$DH$1:$DK8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$V$3,$DL$1:$DO8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$S$3,$DL$1:$DO8,ROW(),0))))+
(IF($B8="X",(HLOOKUP('Title Recap - All Titles'!$W$3,$DP$1:$DS8,ROW(),0)),(HLOOKUP('Title Recap - All Titles'!$T$3,$DP$1:$DS8,ROW(),0))))

[oeldere]

You get better and quicker help if you follow the advice in the link below.

http://www.excelforum.com/the-water-...-question.html