Counting acceptances and rejections

[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

 

[Don Guillett]

try
=sumproduct((a2:a200="Joe")*(b2:b200="accepts"))

 

[Earl Kiosterud]

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.

 

[Bobby]

Boy. That worked. Scary.

try
=sumproduct((a2:a200="Joe")*(b2:b200="accepts"))