trying to do a COUNT IF NOT formula but its saying there is an invalid character. Code is below. Is there documentation on how to use a count if not formula? Thanks.
- Code: Select all
string other = "COUNTIF(Q2:Q9999,\"<>New South Wales\")";
var otherCount = book.CaculateFormulaValue(other);
string otherVal = otherCount.ToString();