Creating % formula help for log file.
 

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

Creating % formula help for log file.
 

Try this:

A12:A15 = error code description

=IF(COUNTA(D$1:D$10),COUNTIF(D$1:D$10,LEFT(A12))/COUNTA(D$1:D$10),"")

Copy down as needed and format as %

Biff

"Zilla" wrote in message
oups.com...
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