| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF cannot count decimal number occurences
Excel function COUNTIF cannot count decimal number occurences in an array.
Why? What to do? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF cannot count decimal number occurences
try something like:
=COUNTA(A1:A7)-COUNTIF(A1:A7,"-99^99") where A1 thru A7 contain: 1 2 3 4 a b cd will return 4 the number of numbers rather than text -- Gary''s Student gsnu200702 "Ignorasmus" wrote: Excel function COUNTIF cannot count decimal number occurences in an array. Why? What to do? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF cannot count decimal number occurences
Maybe you could just use:
=count(a1:a10) to count the number of numbers. Ignorasmus wrote: Excel function COUNTIF cannot count decimal number occurences in an array. Why? What to do? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences within a time range | Excel Discussion (Misc queries) | |||
| Command to count number of worksheets in a workbook? | Excel Worksheet Functions | |||
| COUNTIF across a number of worksheets | Excel Worksheet Functions | |||
| How do I stop decimal being placed in a 3 digit whole number | Setting up and Configuration of Excel | |||
| Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
Linear Mode
