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