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