xcruc1at3r
Member
=SUMPRODUCT(((CCO!$E$5:$E$600="SIN")*(CCO!$C$5:$C$600="H40"))+((CCO!$E$5:$E$600="CMB")*(CCO!$F$5:$F$600="CMB")*(CCO!$C$5:$C$600="H40"))+((CCO!$E$5:$E$600="CMB")*(CCO!$F$5:$F$600="CHT")*(CCO!$C$5:$C$600="H40"))+((CCO!$E$5:$E$600="CMB")*(CCO!$F$5:$F$600="VME")*(CCO!$C$5:$C$600="H40"))+((CCO!$E$5:$E$600="LCB")*(CCO!$C$5:$C$600="H40"))-((CCO!$E$5:$E$600="SIN")*(CCO!$F$5:$F$600="MEL")*(CCO!$C$5:$C$600="H40"))-((CCO!$E$5:$E$600="SIN")*(CCO!$F$5:$F$600="SYD")*(CCO!$C$5:$C$600="H40"))-((CCO!$E$5:$E$600="SIN")*(CCO!$F$5:$F$600="ADL")*(CCO!$C$5:$C$600="H40"))-((CCO!$E$5:$E$600="SIN")*(CCO!$F$5:$F$600="BNQ")*(CCO!$C$5:$C$600="H40"))-((CCO!$F$5:$F$600="BRB")*(CCO!$C$5:$C$600="H40"))-((CCO!$F$5:$F$600="BNL")*(CCO!$C$5:$C$600="H40"))-((CCO!$F$5:$F$600="RHD")*(CCO!$C$5:$C$600="H40"))+((CCO!$F$5:$F$600="DHK")*(CCO!$C$5:$C$600="H40")))
is there any way to trim this formula !!
is there any way to trim this formula !!