Countif

G

Guest

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)
 
G

Gord Dibben

COUNT function counts numbers only.

COUNTA functions counts non-blank cells.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
count until blank cell 2
Excel Use COUNTIF across a range of cells with formulas 0
COUNT function - # of occurences a number appears in all cells 26
countifs criteria 4
COUNTIF Cells in Range? 4
Counting Problem 2
Count with merged cells 2

Top