Note that this refers to C32 (and c32 needs to be blank) in order to handle
the empty cells.

=LOOKUP(A1,{0,"a","b","c","d","e","f","g","h"},C32 :K32)+LOOKUP(A2,{0,"a","b","c","d","e","f","g","h" },C32:K32)+LOOKUP(A3,{0,"a","b","c","d","e","f","g ","h"},C32:K32)+LOOKUP(A4,{0,"a","b","c","d","e"," f","g","h"},C32:K32)+LOOKUP(A5,{0,"a","b","c","d", "e","f","g","h"},C32:K32)+LOOKUP(A6,{0,"a","b","c" ,"d","e","f","g","h"},C32:K32)+LOOKUP(A7,{0,"a","b ","c","d","e","f","g","h"},C32:K32)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Peta" wrote:

I am trying, and failing, to put together a formula to reach the following
(in the most simplist way I can explain):

If cells A1 and/or A2 and/or A3 and/or A4....A7 contain the letter:
"A" then = cell D32 +
"B" then = cell E32 +
"C" then = cell F32... through to "H"=K32

So essentually if only "B", "D" and "F" were keyed in to A2, A4, A5 (in any
order and only one letter per cell), the sum total would be calculated as
D32+G32+I32.

Is anyone able to please advise? Much appriciated