Countif
Q1:
=SUMPRODUCT(--($B$2:$B$4="male"),--($C$2:$C$4="yes"))
=SUMPRODUCT(--($B$2:$B$4="male"),--($C$2:$C$4="no"))
Q2:
=SUMPRODUCT(--($B$2:$B$4="male"),--($D$2:$D$4="yes"))
=SUMPRODUCT(--($B$2:$B$4="male"),--($D$2:$D$4="no"))
HTH
"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
example
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
thanks
stuart
|