We're sorry Aspose doesn't work properply without JavaScript enabled.

# Exception occurs while setting formula containg SUM and COUNTIF functions

Hi,
We have a requirement where we have to show values in some cells based upon a formula. The formula that has to be set contains functions SUM and COUNTIF.
But while setting formula with these functions we are getting following exceptions :

=COUNTIF(\$F\$9:\$ZA\$9;3)
java.lang.IllegalArgumentException: You have entered too few parameters for function COUNTIF

&&

sum(=COUNTIF(\$‘sheet name’.\$F\$9:\$ZA\$9;3))
java.lang.IllegalArgumentException: Unsupported formula : =SUM(COUNTIF(\$‘sheet name’.\$F\$9:\$ZA\$9;3)).

In case of SUM it is appending ‘.’ in the end of formula string.

Please let me know where is the problem?

Thanks

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please use comma instead of semi colin as a parameter separator in your formula. Please modify your formula as below:

=COUNTIF(\$F\$9:\$ZA\$9,3)

=SUM(COUNTIF(\$F\$9:\$ZA\$9,3))

Thank You & Best Regards,

Hi,
Thanks for your quick response.

We are now using comma instead of semi colon still it is throwing the below mentioned exception :
=COUNTIF(\$‘sheet name’.\$F\$9:\$ZA\$9,3)
java.lang.IllegalArgumentException: Unsupported formula : =COUNTIF(\$‘sheet

name’.\$E\$10:\$AL\$10,1).

The same exception also occurs when we are using SUM function in the formula.

Thanks,

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please update your formula as mentioned below, if you still face any problem, please share your code and template file to show the issue. We will check it soon.

=COUNTIF('sheet name'!\$F\$9:\$ZA\$9,3)

=SUM(COUNTIF('sheet name'!\$F\$9:\$ZA\$9,3))

Thank You & Best Regards,