yjyong
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.
vvaidya
(Vinay Vaidya)
2
Try
"=COUNTIFS(A6:A255,"""K""",J6:J255,"""Red""")"
If it works: Credits @ddrdushy1
1 Like
ddrdushy1
(Dushyanth)
3
“=COUNTIFS(A6:A255,”“”“K”“”“,J6:J255,”“”“Red”“”“)”
Hi,
Is there a way to execute a formula on all rows of column A?
Regards,
Shawn