Sheet that totals amount of instances.

[adamginger]

I have a sheet to log incidents and I would like to complete a sheet for daily statistics. For example, if one person (name in cell A1) attended an incident (data validated from a separate list in B1) then on a separate sheet, I would like a total amount of those incidents that the particular person dealt with.
This is duplicated down the incident sheet so each name would be on a separate row in column A, and the specific incident code would be in each row in column B.

On the stats page each person would be along the top of a table and each possible incident code would be down the side, every time an incident occurs it would add 1 to the total for the person that dealt with it.

Sorry if this is quite difficult to simulate, if you need any more info about the project, let me know and I'll try to explain it a bit better.

Thank you in advanced for your replies.
(I would prefer if this completed using formulas rather than macros as I'm trying to complete this project macro free, however if needs be, I can add macros)

 

[etaf]

a pivot table should do that for you
see here
sheet 1
is a list of names and codes
sheet 2
is summary
using a pivot table
https://www.dropbox.com/s/j4cucty1gqslbzd/pivot table sample_etaf.xlsx?dl=0

 

[adamginger]

a pivot table should do that for you
see here
sheet 1
is a list of names and codes
sheet 2
is summary
using a pivot table
https://www.dropbox.com/s/j4cucty1gqslbzd/pivot table sample_etaf.xlsx?dl=0

Fantastic, thanks for your response, I'll take a look and give it a try!