This is a migrated thread and some comments may be shown as answers.

How do you correctly use the COUNTIF built-in Excel function?

1 Answer 55 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Nicholas
Top achievements
Rank 1
Nicholas asked on 23 May 2019, 05:28 PM

I'm trying to use the built-in Excel function COUNTIF on a cell range. How do you return the integer result of that value? Do I have to specifically set the formula to a cell first and get the result that way? Or can I somehow just get the result without actually having to write the formula to a cell? 

 

Thank you in advance.

1 Answer, 1 is accepted

Sort by
0
Tanya
Telerik team
answered on 27 May 2019, 03:59 PM
Hello Nicholas,

At this point, evaluating the result of a function outside of a cell value is not supported and you will need to add the function as a value of a cell so you can calculate its final result. I logged a request on your behalf to expose a similar functionality for the SpreadProcessing model used in RadSpreadsheet: SpreadProcessing: Expose API allowing to calculate the result value of a formula without adding the formula as a cell value. You can vote for the task to increase its priority.

If it is an option for you, you can use SpreadProcessing to perform the desired calculations in a separate workbook and show only the relevant values in the UI control. You can find more information on how to work with the functions in the model in the Formulas help section.

Hope this is helpful.

Regards,
Tanya
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
Spreadsheet
Asked by
Nicholas
Top achievements
Rank 1
Answers by
Tanya
Telerik team
Share this question
or