help with a formula

[andrumu]

hi,

I have a sumproduct formula that basically works fine; but i now i wanna reuse it for another purpose. unfortunately it is not working, the only thing that changed is that the lookup value is always a number but sometimes a text. how can i get this thing to work?

formula looks like this/

=sumproduct(--(a1:a100=number1);--(b1:b100=number2);--(c1:c100=text);(d1:d100))

note that the D column also contains text; and that there are redundant cases,which means that the same combination exists several times though the result is also the same.

i hope somebody can help me there

regards

andre
<!-- / message -->

 

[xld]

Do you mean this

=sumproduct(--(a1:a100=number1);--(b1:b100=number2);--(c1:c100="text");--(d1:d100))

 

[andrumu]

well the thing is that the text is put straight in the formula but referred from another cell...

 

[xld]

Well I am sure that means something to you, but it flies straight over me.