Writing Excel Formula using Write Cell

Build
#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.PNG708×172 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.

Trying to write a formula to excel cells
Adding a column in existing excel
#2 
Try

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

If it works: Credits @ddrdushy1

1 Like
#3

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

#5

Hi,

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

Regards,
Shawn