| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need column evaluated to count total of occurrences of "Y". How?
I need to create a logic function to evaluate each cell in a specified range
to see if each cell contains "Y". If the cell contains "Y", then the number "1" needs to be added to the running total. I want to know the total number of "Y" in the column or specified range. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need column evaluated to count total of occurrences of "Y". How?
=COUNTIF(A:A,"Y")
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "learning" wrote in message ... I need to create a logic function to evaluate each cell in a specified range to see if each cell contains "Y". If the cell contains "Y", then the number "1" needs to be added to the running total. I want to know the total number of "Y" in the column or specified range. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need column evaluated to count total of occurrences of "Y". H
Very kind of you to help out. I will try it.
"Peo Sjoblom" wrote: =COUNTIF(A:A,"Y") -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "learning" wrote in message ... I need to create a logic function to evaluate each cell in a specified range to see if each cell contains "Y". If the cell contains "Y", then the number "1" needs to be added to the running total. I want to know the total number of "Y" in the column or specified range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Count Occurrences and Print Total | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
| Count cells based on date range in another column | New Users to Excel | |||
Linear Mode
