ExcelBanter - Countif

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

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

- - Countif (https://www.excelbanter.com/excel-discussion-misc-queries/166463-countif.html)

Countif

I am trying to count the number of cells that have a number in it. I would
suspect that the COUNTIF function would be the one but how can I get to count
only if the cell contains a number (the numbers will all be different)
--
pk

Mike H

Countif

try

=COUNT(A1:A100)

Mike

"PK" wrote:

I am trying to count the number of cells that have a number in it. I would
suspect that the COUNTIF function would be the one but how can I get to count
only if the cell contains a number (the numbers will all be different)
--
pk

Gord Dibben

Countif

COUNT function counts numbers only.

COUNTA functions counts non-blank cells.

Gord Dibben MS Excel MVP

On Sat, 17 Nov 2007 02:46:00 -0800, PK wrote:

I am trying to count the number of cells that have a number in it. I would
suspect that the COUNTIF function would be the one but how can I get to count
only if the cell contains a number (the numbers will all be different)

All times are GMT +1. The time now is 08:38 AM.