Maybe it is an array formula, it should be committed with Ctrl-Shift-Enter,
not just Enter?

Why don't you post it?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mark Ch" <Mark wrote in message
...
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