Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting nonblank and non white space cells | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions |