Creating % formula help for log file.

Z

Zilla

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

asas.jpg


http://i117.photobucket.com/albums/o43/tazzbware/asas.jpg
 
T

T. Valko

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
 
Top