ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Countif (https://www.excelbanter.com/excel-worksheet-functions/140334-countif.html)

 Stuart April 25th 07 11:04 AM

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

 Toppers April 25th 07 01:10 PM

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

 Teethless mama April 25th 07 02:50 PM

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

 T. Valko April 25th 07 07:44 PM

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

 All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com