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.

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”""")"