can''t get countif function to work in v 3.3 final

[Byron Tate]

I have 2 issues - result value, and syntax.

countif description says:

---------------------------------------
Counts the number of cells within a range that meet the given criteria.

Syntax

COUNTIF(range,criteria)

range is the range of cells from which you want to count cells.

criteria is the criteria in the form of a number, expression, or text that defines which cells will be counted. For example, criteria can be expressed as ">32".

------------------------------------------------

This seems to say that if A1 = 0 and A2 = 1, then
=countif(A1:A2,NOT(A0 = 0))

should result in a value of 1 (assume ''using zero row notation'' is on). But my testing shows that it results in a value of 0 on line 1 and 2 on line 2. It''s as if the logic is actually ''return the count of A1:A2 if the current line''s A column is not = 0, otherwise return 0''.

Second issue: I can''t just write:

=countif(A1:A2,">0")

because it complains about the second arg. Also I can''t write:
=countif(A1:A2,A0 = 1)

because it complains that there are not enough args on the stack, which means it did not recognize ''A0 = 1'' as an expression. I''ve seen this problem before.

[Administrator]

Where are you seeing these results? If I open \Essential Studio\3.3.0.0\Windows\Calculate.Windows\Samples\DataGridCalculator,and enter this formula into cell B4, it comes back with the value of 2.

=countif(a1:a3, ">1")

[Byron Tate]

I confirm that the demos work correctly for countif. I apologize for not trying them first. The problem is more complicate because I''m using some unpublished public methods on the engine. I get and use the Parse method like this, as per instructions I got from one of my Direct-trac issues concerning performance for large grids:

System.Reflection.MethodInfo ParseFormulaInfo;
private string ParseFormula(string formula)
{
if(ParseFormulaInfo == null)
{
ParseFormulaInfo = typeof(GridFormulaEngine).GetMethod("Parse",
System.Reflection.BindingFlags.Instance |
System.Reflection.BindingFlags.InvokeMethod |
System.Reflection.BindingFlags.Public
, null, new Type[1]{typeof(string)}, null);
}

object os = null;
if(ParseFormulaInfo != null)
{
os = ParseFormulaInfo.Invoke(m_Engine, new object[]{formula});
}
return os.ToString();
}

I call my function, ParseFormula with a string which is one of my named ranges preceeded by ''=''.

"count(J1:J2)" works OK as the value of the named range.

But in this case the value of the named range is:

"countif(J1:J2,\">1200\")"

the countif statement gives an ArgumentOutOfRangeException, which occured in mscorlib.dll, with added info "Length cannot be less than zero"

I understand that I have a non-standard use of the engine here, and it''s working great so far with all my issues that have been posted in direct-trac. I have not ever tried this particular function up till now, and I know I could write my own. So I don''t expect you to spend a lot of time debugging this since you don''t have my complete code setup.

[Administrator]

The problem is with using quoted strings inside namedranges. These are not being parsed properly(strings are cached before the namedranges are substituted-meaning that the strings inside namedranges are not properly cached). We will have to fix this in our source code. I do not know of a work around for this.