"Tushar Mehta" wrote:

In article ,
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??