Countif Array

By Albert.Hay2 ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums