| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Values
Can anybody advise me on the formula for the following:
I am wanting to auto count values in a cell range e.g A1:A10 The data in these cells will only be a "X" OR "Y", i only want excel to count the "Y" values & ignore the "X" values? Any suggestions or solutions would be most appreciated. Kind Regards Paul |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Values
The countif function should do it -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=530837 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Values
=COUNTIF(A1:A10,"Y")
HTH -- AP "crawshawpaul" a écrit dans le message de ... Can anybody advise me on the formula for the following: I am wanting to auto count values in a cell range e.g A1:A10 The data in these cells will only be a "X" OR "Y", i only want excel to count the "Y" values & ignore the "X" values? Any suggestions or solutions would be most appreciated. Kind Regards Paul |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Values
Hey thanks alot
Probably a stupid question to ask, so all the more thanks for your reply. Kind Regards Paul "Ardus Petus" wrote: =COUNTIF(A1:A10,"Y") HTH -- AP "crawshawpaul" a écrit dans le message de ... Can anybody advise me on the formula for the following: I am wanting to auto count values in a cell range e.g A1:A10 The data in these cells will only be a "X" OR "Y", i only want excel to count the "Y" values & ignore the "X" values? Any suggestions or solutions would be most appreciated. Kind Regards Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Counting Values on a condition | Excel Worksheet Functions | |||
| If Then, not using values, or not counting blanks | Excel Worksheet Functions | |||
| Counting Values | Excel Discussion (Misc queries) | |||
| Counting values | Excel Worksheet Functions | |||
Hybrid Mode
