Thread: Countif
View Single Post
  #2   Report Post  
Old April 25th 07, 01:10 PM posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default Countif








"stuart" wrote:

hi everyone

wonder if any of you can help

is it possible to use the countif function on a data source onto which ive
put autofilters


name gender question 1 question 2
Bob male yes yes
Stuart male no yes
mary female yes yes

i want to be able to put an autofilter on the gender column, then have a
countif on q1 and q2 columns to count how many say yes and no - eg if i
selected male, q1 would be 1*yes and 1*no, and q2 would be 2*yes and 0*no

hope there is somewhere out there that can help