Too few arguments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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")
 
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")
Click to expand...
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
 
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")
Click to expand...

You need a comma in there after g19.

Rgds
Richard Buttrey
__
 
Tushar Mehta said:
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
Click to expand...


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