Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif
When using the countif formula, how can i have it count the cells that have
any text in them? |
#2
|
|||
|
|||
if you have a combination of numbers and text in a range
try =counta(range)-count(range) "Todd Nelson" wrote: When using the countif formula, how can i have it count the cells that have any text in them? |
#3
|
|||
|
|||
Array-entered, meaning you commit with Ctrl-Shift-Enter
=SUMPRODUCT(--(ISTEXT(A1:A6))) "Todd Nelson" wrote: When using the countif formula, how can i have it count the cells that have any text in them? |
#4
|
|||
|
|||
Try...
=COUNTIF(A1:A100,"?*") Note that formula blanks "" are excluded from the count. Hope this helps! In article , "Todd Nelson" wrote: When using the countif formula, how can i have it count the cells that have any text in them? |
#5
|
|||
|
|||
No need to array-enter. Simple entry will work fine.
Bob Umlas Excel MVP "Duke Carey" wrote in message ... Array-entered, meaning you commit with Ctrl-Shift-Enter =SUMPRODUCT(--(ISTEXT(A1:A6))) "Todd Nelson" wrote: When using the countif formula, how can i have it count the cells that have any text in them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF help | Excel Worksheet Functions | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |