multiple sumproducts and now formula is too long
 

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:C100 0)

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((con dition3=c)*(condition4=d)),C1:C1000)

thanks in advance

multiple sumproducts and now formula is too long
 

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

thanks

sam

"sam" wrote:

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:C100 0)

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((con dition3=c)*(condition4=d)),C1:C1000)

thanks in advance

multiple sumproducts and now formula is too long
 

<%
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

---
frmsrcurl: http://msgroups.net/microsoft.public...la-is-too-long

multiple sumproducts and now formula is too long
 

<%
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

---
frmsrcurl: http://msgroups.net/microsoft.public...la-is-too-long