Excel formula in Write Cell

Help
1

Hi all,

I’m trying to write a Countif formula in a particular cell.

So first I write the particular parameter in cell AE1 (To postpone)
Then I write the countif in cell AE2.

I keep getting the message:

What did I do wrong?

1 Like
2

Hey @DelOli

Tried like this A<Row Number>?

It is inside citrix or local?

Local- It is working for me.
For your reference:

excel_formula.jpg467×517 20.9 KB

For citrix you can follow: Navigate to the column by using Hot key ‘ctrl+g’ and with type into and enter go there then you can use “type into” with “k[enter]” or enter hot key as a separate.

let me know if you have any doubts on this.

Regards…!!
Aksh

1 Like
3

Local for now.

“=SUM()” works fine, but the “=COUNTIF()” doesn’t.

4

Hey @DelOli

It is working for me :slight_smile:

excel_formula.jpg467×517 22.8 KB

Regards…!!
Aksh

1 Like
5

Thanks a lot! So the solution: use , instead of ;

2 Likes
6

How do i add “" in the string e.g. =CONCAT(A1,"”,B1)

7

Use Chr(34) or three time double quote “”" which gives One Double quote Output