Too few arguments

[plore]

if i use the following formula it gives me an error message that reads as
follows:
You've entered too few arguments for this function??
Can anybody tell me why?

=COUNTIF(g12:g19 ">5")

 

[Tushar Mehta]

if i use the following formula it gives me an error message that reads as
follows:
You've entered too few arguments for this function??
Can anybody tell me why?

=COUNTIF(g12:g19 ">5")

You are missing a delimiter between the range and the criterion.
Depending on localization, it can be a comma or a semicolon.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Richard Buttrey]

if i use the following formula it gives me an error message that reads as
follows:
You've entered too few arguments for this function??
Can anybody tell me why?

=COUNTIF(g12:g19 ">5")

You need a comma in there after g19.

Rgds
Richard Buttrey
__

 

[plore]

You are missing a delimiter between the range and the criterion.
Depending on localization, it can be a comma or a semicolon.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Even if i use the formula as follows the error message appears again

=COUNTIF(g12:G19;>5)
=COUNTIF(g12:g19,>5)
=COUNTIF(g12:g19,".5")
=COUNTIF(g12:g19;">5")

Could it be a problem with my program because if i use the formula on a
different workstation it works??