Too few arguments

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

In article <[email protected]>,
[email protected] says...
> 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

On Wed, 23 Nov 2005 04:06:02 -0800, "plore"
<[email protected]> wrote:

>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
__

"Tushar Mehta" wrote:

> In article <[email protected]>,
> [email protected] says...
> > 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
>


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