CountIf: Syntax and Examples?

M

Michael

Hi,

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

Thanks,
Mike
 
R

Ron de Bruin

Hi

What is wrong with the Excel Help?

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

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

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?
 
R

Ron de Bruin

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