Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF < ""
My Range contains text values. The blanks are not really blank but rather "".
I would like to count if < to "" as an array formula but I get zero. See below (n.b have done ctrl+shift+enter) =COUNT(IF($B$10:$B$21<"""",$B$10:$B$21)) Bruce |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF < ""
Use following (not Array) formula:
=COUNTIF(B10:B21,"") HTH -- AP "Bruce" a écrit dans le message de news: ... My Range contains text values. The blanks are not really blank but rather "". I would like to count if < to "" as an array formula but I get zero. See below (n.b have done ctrl+shift+enter) =COUNT(IF($B$10:$B$21<"""",$B$10:$B$21)) Bruce |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF < ""
Try this............
=COUNTA(A1:A22)-COUNTBLANK(A1:A22)-COUNT(A1:A22) Vaya con Dios, Chuck, CABGx3 "Bruce" wrote: My Range contains text values. The blanks are not really blank but rather "". I would like to count if < to "" as an array formula but I get zero. See below (n.b have done ctrl+shift+enter) =COUNT(IF($B$10:$B$21<"""",$B$10:$B$21)) Bruce |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF < ""
Hi
=COUNTIF($B$10:$B$21,"<") -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Bruce" wrote in message ... My Range contains text values. The blanks are not really blank but rather "". I would like to count if < to "" as an array formula but I get zero. See below (n.b have done ctrl+shift+enter) =COUNT(IF($B$10:$B$21<"""",$B$10:$B$21)) Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals by count | Excel Discussion (Misc queries) | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |