Quote:
Originally Posted by xor
As an alternative to the formula in the file 'Type Factor Value Total_2' you can use:
=SUMPRODUCT(--(G3=$B$3:$B$10),($C$3:$C$10))*F3
in row 3 and copy down.
|
Thank you very much XOR for the help. the first solution works fine for me.
very much appreciated
best
Jamal