Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Text Data
Using 2007 on Vista
If I've got text data which in some columns either has data or there is a blank, what formula do I use to count how many cells have text in them per column? Many thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Text Data
=COUNTA(A2:A200)
will count everything except blanks post back if you have numbers as well that should not be counted -- Regards, Peo Sjoblom wrote in message ... Using 2007 on Vista If I've got text data which in some columns either has data or there is a blank, what formula do I use to count how many cells have text in them per column? Many thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Text Data
On Thu, 26 Jun 2008 11:55:59 -0700, "Peo Sjoblom"
wrote: =COUNTA(A2:A |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Text Data
Thanks
I did just that In my case it's " =COUNTA(A2:A1293)" I then dragged this formula along the bottom of each column Despite some columns have less data than in col a, all columns show the same result 1292 How can this be? On Thu, 26 Jun 2008 11:55:59 -0700, "Peo Sjoblom" wrote: =COUNTA(A2:A200) will count everything except blanks post back if you have numbers as well that should not be counted |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Text Data
Hi
Perhaps you have calculation mode set to Manual ToolsOptionsCalculationautomatic -- Regards Roger Govier wrote in message ... Thanks I did just that In my case it's " =COUNTA(A2:A1293)" I then dragged this formula along the bottom of each column Despite some columns have less data than in col a, all columns show the same result 1292 How can this be? On Thu, 26 Jun 2008 11:55:59 -0700, "Peo Sjoblom" wrote: =COUNTA(A2:A200) will count everything except blanks post back if you have numbers as well that should not be counted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum / count data from text string with delimiter | Excel Worksheet Functions | |||
how can i count text in a ranges of data | Excel Worksheet Functions | |||
Group and Count Text Data More Efficiently | Excel Worksheet Functions | |||
count G4:G51 for critera only if D4:D51 contains text data | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |