Too few arguments

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

plore - 23 Nov 2005 12:06 GMT

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

Reply to this Message

Tushar Mehta - 23 Nov 2005 12:11 GMT

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

Signature

Regards,

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

Reply to this Message

plore - 23 Nov 2005 12:45 GMT

> > if i use the following formula it gives me an error message that reads as
> > follows:
[quoted text clipped - 5 lines]
> You are missing a delimiter between the range and the criterion.
> Depending on localization, it can be a comma or a semicolon.

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

Reply to this Message

Richard Buttrey - 23 Nov 2005 12:43 GMT

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

Reply to this Message