Countif Array

Hi,
I have a worksheet that tracks “indidents”. Column A lists the name responsible for the incident. A name can appear in several rows for different incidents. Col B is a description of the indicent, Col C is a descrition of the corrective action, Col D is a status, open or closed.
I am trying to figure out how to write an array that will give me the count of how many times the name appears in a given time, and count the number of open indicents the name has. I appreciate any help or direction.