Formula to long
I need to use this formula in excel 2002, but I am getting the error about it
being to long any ideas?
=SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220210"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220810"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220220"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220310"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2210220320"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220410"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220420"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220421"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220821"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220422"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220510"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220520"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220110"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220120"))+SUMPRODUCT(--(DATA!$A$2:$A$19000="DEC06"),--(DATA!$D$2:$D$19000="Frontline"),--(DATA!$M$2:$M$19000="2110220121"))
|