Export to Excel, and add a cell to 'count if'
Posted on 2011-10-10
I have a working code that exports records to Excel. I have been asked to add columns that do simple calculations. The only one I can't get to work is COUNTIF.
SUM, COUNT, and COUNTA all work, but COUNTIF DOESN'T.
For example, the code reads
xlsheet.Cells(3,2).Value = "=SUM(A1:A13)"
xlsheet.Cells(4,2).Value = "=COUNTA(A14:A20)
'This throws an error
xlsheet.Cells(11,2).Value = "=(countif(c3:c13),"Y")"
the error is:
Unexpected Y: Expected End-Of-statement: Operator
I can't find anything in lotusscript references. This is the last piece of this project - I'm desparate! Is this possible?