Excel: Attendance Register how to count....

Hi there, Like the above recently I've created an attendance register. I have names in rows and the dates in columns. If someone is either present, absent or on holiday in the cells relatively I type values P, A or H. Below the main table with my data I created a data validation list from which I want to choose a particular name and I want excel to count for me how many days that person was either present, absent or on holiday. I've tried many ways already using countifs, countif, and if functions and acutally it worked but it doesn't happen dynamically. If I change the name of a person I want the values to change as well. Thank you in advance for help.

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of May 09, 2015.

For more resources for Microsoft Excel