ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Too few arguments (https://www.excelbanter.com/excel-worksheet-functions/56935-too-few-arguments.html)

plore

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

Tushar Mehta

Too few arguments
 
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

Richard Buttrey

Too few arguments
 
On Wed, 23 Nov 2005 04:06:02 -0800, "plore"
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
__

plore

Too few arguments
 


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

aerlank

"You've entered too few arguments for this function"

I get the error for any function i use since upgrading to EXCEL 2007. I would love to get this fixed.

Edd1986

i have a similar problem same message different equation can anyone please help?

=(round(E7*10%)


All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com