I paste it with a group of other formulas, all others work exactly as desired, but this one does not calculate correctly until I re-edit it (without changing, I just press F2 and then Enter)
I think it must be because of COUNTIF, but I can not solve this. The only solution I could find to this issue(except editing content) is changing each "=" with itself (ctrl+H)
Does someone might have an idea to solve this?
Code: Select all
ADdwa = oSheet.getcellrangebyname("AD2")
ADdwa.formula= "=IF(AA2="&""""""&";"&""""""&";AA2+COUNTIF(AA$2:AA2;AA2)*0,01)"