View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default Counting based on values in two columns?

Create a pivot table

"Brother of Andrew" wrote:

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!