Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count cells in a range
I posted this yesterday but have not seen it.
Excel XP & Win XP In VBA, Range(Whatever).Count produces the number of cells in the range, regardless of the contents of the cells. Is there a worksheet formula that does the same? Not a UDF, but a plain formula? Thanks for your time. Otto |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count cells in a range
Hi Otto,
Try the following. While it appears to be looking for not blank, for me under testing that I have done it appears to count all cells whether they are blank or not. However, I suggest that you test it under the circumstances where you intend to use it. There is a separate COUNTBLANK function and I suggest it is there because the COUNTIF function fails trying to count blanks as a criteria. I'll be interested if you find any circumstances where it does not work. =COUNTIF(D1:G20,"<""") -- Regards, OssieMac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count cells in a range | Excel Discussion (Misc queries) | |||
Count how many different cells are in a range | Excel Discussion (Misc queries) | |||
Count Certain Cells in Specified Range | Excel Worksheet Functions | |||
count cells in a range | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |