Hello Folks
Please can u help!

On my worksheet call GFSA, in any the the cells C8 to C29 I have a name. It
could be Big Rick in C8 only, or Big Rick in C8, C12, and C20.
What is require is a formula in another sheet (called Calc) that will total
the value from the corresponding Q column.

Eg. GFSA sheet Cell C8="Big Rick" the give me the total from Q8
but if Big Rick is in cells c8,c12, and C20 then give me the total from Q8,
Q12 and Q20.

Hoping you can understand this logic.

Your help is and always has been very much appreciated.
Thanking you in anticipation.
--
Big Rick