Le 20 déc. 2009 à 10:55, Axel Luttgens a écrit :
Le 20 déc. 2009 à 00:36:22, Paul Berkowitz a écrit :
[...]
I'm very curious to know whether that "=COUNTIF(C8:C600,4.2)" works in Excel
or whether there is a workaround that works.
Hello Paul,
It doesn't seem to work here (Excel 2004, 11.5.6 (090928) - System: 10.6.2, french, "," as decimal separator); making use of it is silently discarded:
tell application "Microsoft Excel"
set formula of selection to "9999"
formula of selection
--> "9999"
set formula of selection to "=COUNTIF(B1,4.2)"
formula of selection
--> "9999"
set formula of selection to "=COUNTIF(B1,A2)"
formula of selection
--> "9999"
set formula of selection to "=COUNTIF(B1;4,2)"
formula of selection
--> "=COUNTIF(B1;4,2)"
formula local of selection
--> "=NB.SI(B1;4,2)"
set formula of selection to "=COUNTIF(B1;A2)"
formula of selection
--> "=COUNTIF(B1;A2)"
formula local of selection
--> "=NB.SI(B1;A2)"
end tell
It also appears that, in contradiction of Jan's experience, I have to make use of the semicolon as argument separator when building a formula. Go know...