Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions to count Yes & No
Hi There,
I have a simple excel table, in one of the fields that is called "filled" the answer is either (yes) or (no), I simply want to count how many "yes" and how many "no" are there in that column, which function to use for that. ------------------------------------------------------------------------- Filled Yes Yes No No Total Yes: ----- Total No: ----- ------------------------------------------------------------------------- Thank you in advance for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions to count Yes & No
Assuming range is A1:A100 =COUNTIF(A1:A100,"yes") =COUNTIF(A1:A100,"no") -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551637 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions to count Yes & No
=COUNTIF(A:A,"yes") assuming that the "filled" column is A *and* the
result (this formula) is in a column *other* than A Regards Trevor "fofo" wrote in message ... Hi There, I have a simple excel table, in one of the fields that is called "filled" the answer is either (yes) or (no), I simply want to count how many "yes" and how many "no" are there in that column, which function to use for that. ------------------------------------------------------------------------- Filled Yes Yes No No Total Yes: ----- Total No: ----- ------------------------------------------------------------------------- Thank you in advance for your help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions to count Yes & No
Try =COUNTIF(filled,"yes")
HTH Regards, Howard "fofo" wrote in message ... Hi There, I have a simple excel table, in one of the fields that is called "filled" the answer is either (yes) or (no), I simply want to count how many "yes" and how many "no" are there in that column, which function to use for that. ------------------------------------------------------------------------- Filled Yes Yes No No Total Yes: ----- Total No: ----- ------------------------------------------------------------------------- Thank you in advance for your help. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
functions to count Yes & No
To count Yes use this formula.
=COUNTIF(A:A,"Yes") where A:A is the "filled" column. Gord Dibben MS Excel MVP On Tue, 13 Jun 2006 12:49:02 -0700, fofo wrote: Hi There, I have a simple excel table, in one of the fields that is called "filled" the answer is either (yes) or (no), I simply want to count how many "yes" and how many "no" are there in that column, which function to use for that. ------------------------------------------------------------------------- Filled Yes Yes No No Total Yes: ----- Total No: ----- ------------------------------------------------------------------------- Thank you in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count interstitial blank cells? | Excel Discussion (Misc queries) | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Count and Count if funtions | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |