Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif
=SUBTOTAL(3,C5:C7)
"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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif
Here's a small sample file:
Countif_filter.xls 14kb http://cjoint.com/?ezuQhoggrD Biff "stuart" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif ? | Excel Discussion (Misc queries) | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |