Writing Excel Formula using Write Cell

[yjyong]

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.

[vvaidya (Vinay Vaidya)]

Try

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

If it works: Credits @ddrdushy1

[ddrdushy1 (Dushyanth)]

@vvaidya

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

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

[shawnmurray]

Hi,

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

Regards,
Shawn