The OP replied in a different thread that he got it working.

John wrote:

Is there anyway I can include the value of the cell with a * but not perform
the average for that sepcific cell:

for example

55,67,89*,22,37

the totals would be 270 but the average would be /4 and not /5 because of
the *

Thanks for any help

John

--

Dave Peterson