| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
