Writing Excel Formula using Write Cell

#1

Hi,

I want to write this formula =COUNTIFS(A6:A255,“K”,J6:J255,“Red”) into the write cell under excel application scope but have this error.

Capture
Capture.PNG708x172 6.29 KB

Is there any way I can work this around? Must be something to do with the quotations. The quotations are needed for excel formula integration.

#2 
Try

"=COUNTIFS(A6:A255,"""K""",J6:J255,"""Red""")"

If it works: Credits @ddrdushy1

#3

“=COUNTIFS(A6:A255,”""“K”""",J6:J255,"""“Red”""")"