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