I want to use a function to count items in one column based on values in another. For example… here is some sample data…
Solution Manning, Jean
Implementation Manning, Jean
Root Cause Manning, Jean
Implementation Lawson, Toni R.
Root Cause Starr, William
Root Cause Starr, William
Root Cause Johnston, Marcus
So I want to know how many items “Manning, Jean” has in Root cause, Solution, and Implementation. I was thinking of COUNTIF but not sure how to put it together so that the criteria all works. Countif only takes one argument and am not quite sure how to nest them (if that is how it has to be done) to get it to work.
Thanx so much for any assistance that can be rendered.
Dennis
