ExcelBanter - Counting Full cells

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting Full cells (https://www.excelbanter.com/excel-worksheet-functions/11786-counting-full-cells.html)

Metolius Dad

Counting Full cells

Is there a function that will give a count of the number of cells in a range
that are occupied by a numeric value? Same question again but occupied by a
text value.

TIA for any assistance
Sam Beardsley

Biff

Hi!

For numeric numbers:

=COUNT(A1:C10)

For text:

=COUNTIF(A1:C10,"*")

Biff

-----Original Message-----
Is there a function that will give a count of the number
of cells in a range
that are occupied by a numeric value? Same question
again but occupied by a
text value.

TIA for any assistance
Sam Beardsley
.

All times are GMT +1. The time now is 03:46 PM.