Writing Excel Formula using Write Cell

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.

Try

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

If it works: Credits @ddrdushy1

1 Like

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

Hi,

Is there a way to execute a formula on all rows of column A?

Regards,
Shawn