Hey if anyone can help it would be much appreciated!

I have a column of 6 cells which can have either A/B, C, D, E etc typed in
them in any order. I need each letter/s to link directly to a particular cell
if typed in any of the 6 cells. If for example D1=C and D4=D then the links
to those two letters need to sum.

The formula I have that doesnt work (and is probably completely wrong) is:

=SUMPRODUCT(--('Exec Sum'!$D$8:$D$13="A/B",'Uplifted NIA to GIA
ft2'!C57,IF('Exec Sum'!$D$8:$D$13="C",'Uplifted NIA to GIA ft2'!D57,IF('Exec
Sum'!$D$8:$D$13="D",'Uplifted NIA to GIA ft2'!E57,IF('Exec
Sum'!$D$8:$D$13="E",'Uplifted NIA to GIA ft2'!F57,IF('Exec
Sum'!$D$8:$D$13="F",'Uplifted NIA to GIA ft2'!G57,IF('Exec
Sum'!$D$8:$D$13="G",'Uplifted NIA to GIA ft2'!H57,IF('Exec
Sum'!$D$8:$D$13="H",'Uplifted NIA to GIA ft2'!I57,0)))))))


--
Peet