ExcelBanter - Count cells in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count cells in a range (https://www.excelbanter.com/excel-discussion-misc-queries/237415-count-cells-range.html)

Otto Moehrbach[_2_]

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

Per Jessen

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

Dave Peterson

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

All times are GMT +1. The time now is 03:05 AM.