Hey hey,
I try to insert a formula to a specific cell. I use COUNT2 formula. I can add it manually to my Excel and it works fine.
“=COUNT2(‘Successful’!A2:A)”
When I use “Write Cell” Activity and open my Excel file it throws an error (invalid name). Then I click the cell and hit enter manually and then the formula is applied.
I defined to save changes and the Excel window is not opened.
Maybe you can tell me how to solve this issue.
Hi @JenJen
Can you please share your input and expected output then it will be helpful to solve the issue.
Regards,
Input
What: “=COUNT2(‘Successful’!A2:A)”
To: Excel.Sheet(“Stats”).Cell(“B9”)
Expected Output: 0
Current Output: Invalid Name Error
If possible can you please share sample input excel and output then it will be more clear to understand the question
Hi @JenJen
The function count2 is a self-defined function? If not, please check whether is ‘count’ instead of ‘count2’.
Seems that this function does not exist with English language settings (only in German as ANZAHL2).
So yeah, it was the wrong formula then.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.