Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Cells in a particular row w/ text
Hi,
Is there a way I can total up all the cells in a range which have any text in them what so ever? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Cells in a particular row w/ text
Hi,
=Counta(A1:A100), will count cells that are not blank if this helps please click yes, thanks " wrote: Hi, Is there a way I can total up all the cells in a range which have any text in them what so ever? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Cells in a particular row w/ text
Try this:
=COUNTIF(A1:A10,"*") That counts TEXT only, ignores numbers. =COUNTA(A1:A10) That will count all non-empty cells regardless of data type. -- Biff Microsoft Excel MVP wrote in message ... Hi, Is there a way I can total up all the cells in a range which have any text in them what so ever? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Cells in a particular row w/ text
Thanks!
On Jun 3, 12:35*pm, "T. Valko" wrote: Try this: =COUNTIF(A1:A10,"*") That counts TEXT only, ignores numbers. =COUNTA(A1:A10) That will count all non-empty cells regardless of data type. -- Biff Microsoft Excel MVP wrote in message ... Hi, Is there a way I can total up all the cells in a range which have any text in them what so ever? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Cells in a particular row w/ text
You're welcome!
-- Biff Microsoft Excel MVP wrote in message ... Thanks! On Jun 3, 12:35 pm, "T. Valko" wrote: Try this: =COUNTIF(A1:A10,"*") That counts TEXT only, ignores numbers. =COUNTA(A1:A10) That will count all non-empty cells regardless of data type. -- Biff Microsoft Excel MVP wrote in message ... Hi, Is there a way I can total up all the cells in a range which have any text in them what so ever? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count blank cells and cells with text | Excel Discussion (Misc queries) | |||
Count Cells with Text Only | Excel Discussion (Misc queries) | |||
Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
How do I count cells with text but ignore cells with spaces? | Excel Discussion (Misc queries) | |||
How do I count cells with text in them? | Excel Discussion (Misc queries) |