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?

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

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

1 Like

Local for now.

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

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

2 Likes

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