| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count cells in a range
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,
=CountA(A1:D100)+CountBlank(A1:D100) Regards, Per "Otto Moehrbach" skrev i meddelelsen ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count cells in a range
=rows(a1:c9)*columns(a1:c9)
is another way to count the cells in A1:C9 Otto Moehrbach wrote: 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many different cells are in a range | Excel Discussion (Misc queries) | |||
| Count a range of cells using an IF | Excel Worksheet Functions | |||
| 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 | |||
![Otto Moehrbach[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
