CountIf: Syntax and Examples?

[Michael]

Hi,

Can someone please refer or give the syntax of CountIf and some
examples and what it mean please?

Thanks,
Mike

 

[Ron de Bruin]

Hi

What is wrong with the Excel Help?

Tell us what you want to do and we can give a example

 

[Michael Sultan]

Hi,

I found nothing whatsoever about "CountIf" in Excel help!?

Mike

 

[Ron de Bruin]

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*")

 

[Steve Garman]

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?

 

[Ron de Bruin]

If you want to use it in code then use
Application.WorksheetFunction.CountIf(.....................