multiple sumproducts and now formula is too long

[sam]

ok guys. here is my problem.

i am using several sumproducts and adding them together to get a value. note
that the range I am suming is the same column.

=sumproduct((condition1=a)*(condition2=b),C1:C1000)+sumproduct((condition3=c)*(condition4=d),C1:C1000)

Anyway I am also using indirects and the formula becomes too long and won't
let me finish it. Is there a way to combine the sumproducts?

=sumproduct(((condition1=a)*(condition2=b))OR((condition3=c)*(condition4=d)),C1:C1000)

thanks in advance

 

[sam]

don't worry. all sorted. just had to put a "+" inbetween the different
conditions.

thanks

sam

 

[Raja]

<
if (oRs("putupto")=("notenterd")) + (oRs("sentto")=("notenterd")) + (oRs("finallydisposed")=("No")) + (oRs("duedaate")<("strEuroDte1")) Then response.write(" Action Not Taken "

%

<
if (oRs("putupto")=("notenterd")) + (oRs("sentto")=("notenterd")) + (oRs("finallydisposed")=("No")) + (oRs("duedaate")=("strEuroDte1")) Then response.write(" Due Date Action Not Taken "
%

Plz solved this problem

 

[Raja]

<%
if (oRs("putupto")=("notenterd")) + (oRs("sentto")=("notenterd")) + (oRs("finallydisposed")=("No")) + (oRs("duedaate")<("strEuroDte1")) Then response.write(" Action Not Taken " )

%>

<%
if (oRs("putupto")=("notenterd")) + (oRs("sentto")=("notenterd")) + (oRs("finallydisposed")=("No")) + (oRs("duedaate")=("strEuroDte1")) Then response.write(" Due Date Action Not Taken " )
%>

Plz solved this problem