| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountIf: Syntax and Examples?
Hi,
Can someone please refer or give the syntax of CountIf and some examples and what it mean please? Thanks, Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CountIf: Syntax and Examples?
Hi
What is wrong with the Excel Help? Tell us what you want to do and we can give a example -- Regards Ron de Bruin http://www.rondebruin.nl "Michael" wrote in message om... Hi, Can someone please refer or give the syntax of CountIf and some examples and what it mean please? Thanks, Mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CountIf: Syntax and Examples?
Hi, I found nothing whatsoever about "CountIf" in Excel help!? Mike *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CountIf: Syntax and Examples?
I found nothing whatsoever about "CountIf" in Excel help!?
Strange, what version of Excel? You don't tell what you want? Count the Word Lada in the range =COUNTIF(A1:A10,"Lada") With a wildcard =COUNTIF(A1:A10,"La*") =COUNTIF(A1:A10,"*Lada*") -- Regards Ron de Bruin http://www.rondebruin.nl "Michael Sultan" wrote in message ... Hi, I found nothing whatsoever about "CountIf" in Excel help!? Mike *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CountIf: Syntax and Examples?
You are looking in Excel help (the one you get when a worksheet is
showing) and not the VBE help (which you get when your VB code is showing) aren't you? Michael Sultan wrote: Hi, I found nothing whatsoever about "CountIf" in Excel help!? Mike *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
CountIf: Syntax and Examples?
If you want to use it in code then use
Application.WorksheetFunction.CountIf(............ ......... -- Regards Ron de Bruin http://www.rondebruin.nl "Steve Garman" wrote in message ... You are looking in Excel help (the one you get when a worksheet is showing) and not the VBE help (which you get when your VB code is showing) aren't you? Michael Sultan wrote: Hi, I found nothing whatsoever about "CountIf" in Excel help!? Mike *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solver examples | Excel Worksheet Functions | |||
| syntax for countif when cells fall within a numerical range | Excel Worksheet Functions | |||
| Need Better Examples for VLOOKUP and the like | Excel Worksheet Functions | |||
| about examples | New Users to Excel | |||
| excel vba - COUNTIF syntax | Excel Programming | |||
![Michael[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
