Excel formula in Write Cell


#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?


Write Cell - Formula Not Calculating
#2

Hey @DelOli

Tried like this A<Row Number>?

It is inside citrix or local?

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

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


#3

Local for now.

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


#4

Hey @DelOli

It is working for me :slight_smile:

Regards…!!
Aksh


#5

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