Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTBLANK function
The CountBlank function counts the number of cells with values in them.
Cells with formulas that return "" (empty text) are counted. Cells with zero values are not counted. Is there a function that will not count cells with formulas that return empty text? Thanks for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTBLANK function
<<<"The CountBlank function counts the number of cells with values in
them." This is *not* true. It counts "blank" cells. This counts *numbers*, without counting nulls (zero length text strings): =COUNT(A:A) This counts *text*, without counting nulls (zero length text strings): =COUNTIF(A:A,"*?") What *exactly are you looking to count? -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Latika" wrote in message ... The CountBlank function counts the number of cells with values in them. Cells with formulas that return "" (empty text) are counted. Cells with zero values are not counted. Is there a function that will not count cells with formulas that return empty text? Thanks for your help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTBLANK function
=ROWS(A1:A10)-COUNTA(A1:A10)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Latika" wrote in message ... The CountBlank function counts the number of cells with values in them. Cells with formulas that return "" (empty text) are counted. Cells with zero values are not counted. Is there a function that will not count cells with formulas that return empty text? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |