Counting acceptances and rejections

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

I have two columns. One is a list of people's names. The other is either
"Accepted" or "Rejected" adjacent to each name.

Each person's name may appear more than once.

How do I count the number of times each person "accepts" or "rejects"?

I've tried COUNTIF but this doesn't seem to do it.

Cheers.

Bobby
 
Bobby,

A pivot table can do this. From your field list, drag the Name header into
the row area, and the header for accepted or rejected into the row area, to
the right of the name header. Also drag that header into the data area. It
will default to count, since they're text.
 
Back
Top