| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count Function?
I have a column in a list that contains several numbers, some of which are
integers and others which have decimal points. Is there a way to count those cells in a column that contain decimals? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count Function?
One way:
=SUMPRODUCT(--(INT(A1:A100)<A1:A100)) In article , jayceejay wrote: I have a column in a list that contains several numbers, some of which are integers and others which have decimal points. Is there a way to count those cells in a column that contain decimals? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count Function?
Suppose you have your numbers in A1:A100 then type this in any cell other
than A1:A100 =SUM(IF(A1:A100-INT(A1:A100)0,1,0)) and press CTRL-SHIFT-ENTER to get the count "jayceejay" wrote: I have a column in a list that contains several numbers, some of which are integers and others which have decimal points. Is there a way to count those cells in a column that contain decimals? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Count Function?
A thousand thanks to the both of you -- Both very helpful. I appreciate it
immensely. "JE McGimpsey" wrote: One way: =SUMPRODUCT(--(INT(A1:A100)<A1:A100)) In article , jayceejay wrote: I have a column in a list that contains several numbers, some of which are integers and others which have decimal points. Is there a way to count those cells in a column that contain decimals? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count function help | Excel Worksheet Functions | |||
| count function | Excel Discussion (Misc queries) | |||
| Count Function | Excel Worksheet Functions | |||
| using the count function | Excel Discussion (Misc queries) | |||
| Count Function | Excel Worksheet Functions | |||
Linear Mode
