Why don't you use a pivot table to do this.

"Brother of Andrew" <Brother of wrote in
message ...
I have a table like this (more or less)

A yes
B no
A no
C yes
A no
c yes

I want to know how many A's are there and how many are yes and how many
are
no? same for B, C...Thank you!