| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count it?
Does anyone have any suggestions on how to count it?
There is a list of name under column A, such as John, Mary, Ann ... I would like to count the number of name under column A, the condition is to count one as long as the cell is not equal to "". Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to count it?
Hi Eric
Try this in Cell B1: =COUNTIF(A:A,"?*") Regards - Dave "Eric" wrote: Does anyone have any suggestions on how to count it? There is a list of name under column A, such as John, Mary, Ann ... I would like to count the number of name under column A, the condition is to count one as long as the cell is not equal to "". Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to count it?
=counta(A:A)
=counta(A2: A5000) -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Eric" wrote in message ... Does anyone have any suggestions on how to count it? There is a list of name under column A, such as John, Mary, Ann ... I would like to count the number of name under column A, the condition is to count one as long as the cell is not equal to "". Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | 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 | |||
Linear Mode
