Employee Statistics

[fdecaria]

I have 30 employees and wish to keep statistics on errors made for every day of the year, summarise and graph for presentation. I have put all employee names on the first column and the date on the first row across the top for every month. Each error is allocated a number such as 1, then categorised by error type such as A,B,C & D. I have then inserted another sheet that summarises the information for the year by using formula =countif(datarange,"A") and so fourth. I then graph information as required. Is there better solution to my needs? Any information appreciated.

 

[Tuelor]

Have you tried a pivot table ? You should be able.to summarize the data neatly using one of these.

D