Dear TheCman81 and Sixthsense,

we are getting closer- with your approach i indeed get the cell to display SUM but it also displays the value of the sum unless i have done something wrong. I would like it to display only SUM while retaining the value of the calculation (=3)

cheers
me