Hi

What i would like to do is to add entries to a log file on a daily
basis. At the end of each entry put one of four main reason codes for
the error. At the bottom of the worksheet list the error codes A - D
and beside each one have a percentage of each of the errors. I know it
sounds confusing so i have included a screen shot of what i mean.

For sample purposes i made it easy by having the percentages as 25%
each. If "A" had 10 entries "B" had 14 and so on how can i create a
formula to reflect that at the bottom of the worksheet.

thanks



http://i117.photobucket.com/albums/o...bware/asas.jpg