I have used a function which works when i check it but dosent display the
total at the end of the row. I have the worksheet handy and can send if
someone can help.

Regards Mark