| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting in exel chart
I have columns of numbers some are interger number some are numbers with
decimal places. I want to count the number of integer numbers in each column any ideas which formula I use. I have tried countif but cant find anyway of specifying the integer number? -- brian exel 2003 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting in exel chart
this is an array formula which must be entered using
ctrl+shift+enter =COUNT(IF(MOD(H3:H6,1)=0,H3:H6)) -- Don Guillett SalesAid Software "brian exel" wrote in message ... I have columns of numbers some are interger number some are numbers with decimal places. I want to count the number of integer numbers in each column any ideas which formula I use. I have tried countif but cant find anyway of specifying the integer number? -- brian exel 2003 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting in exel chart
Thank you for your quick response
-- brian exel 2003 "Don Guillett" wrote: this is an array formula which must be entered using ctrl+shift+enter =COUNT(IF(MOD(H3:H6,1)=0,H3:H6)) -- Don Guillett SalesAid Software "brian exel" wrote in message ... I have columns of numbers some are interger number some are numbers with decimal places. I want to count the number of integer numbers in each column any ideas which formula I use. I have tried countif but cant find anyway of specifying the integer number? -- brian exel 2003 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting in exel chart
Try this:
=SUMPRODUCT(--(MOD(A1:A12,1)=0)) "brian exel" wrote: I have columns of numbers some are interger number some are numbers with decimal places. I want to count the number of integer numbers in each column any ideas which formula I use. I have tried countif but cant find anyway of specifying the integer number? -- brian exel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How I Wok with Exel | New Users to Excel | |||
| Create Chart by Counting Number of Times Data is Used | Excel Discussion (Misc queries) | |||
| how do I convert a non exel tabulation to exel | New Users to Excel | |||
| Excel 12, insert chart does not work. Exel restart. Why? | Charts and Charting in Excel | |||
| Exel | New Users to Excel | |||
Linear Mode
