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

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

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!

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!

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!

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!