multiple sumproducts and now formula is too long

S

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
 
S

sam

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

thanks

sam
 
R

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top