I am running into a parse error while using xlwt. Simple formula's
like SUM() work fine but I tried to run this slight more complex
formula and received the following error.

xlwt.ExcelFormulaParser.FormulaParseException: can't parse formula
=COUNTIFS(hospital_data!C1:C6500,LEFT(B1,4),hospital_data!
D1:D65000,RIGHT(B1,1),hospital_data!F1:F65000,A3)

This is the code I am attempting to run.

hospital_count_formula = '=COUNTIFS(hospital_data!C1:C6500,LEFT({0},
4),hospital_data!D1:D65000,RIGHT({0},1),hospital_data!F1:F65000,
{1})'.format(quarter_ref, state_ref)

sheet_overview.write(row, column, Formula(hospital_count_formula))

I have tried using a defined numerical range (A1:A5000) instead of
(A:A) and I have also tried simply passing this through as a string
but it is not evaluated in Excel.

This formula does work when copy and pasted into Excel. Any thoughts
would be most appreciated.

Thank you!

Kevin

Things to do to get yourself back on the road faster than by asking
questions here:

(1) compare the start of your working SUM formulas with the start of your
problematical COUNTIFS non-formula

(2) have a quick look in this group to see if the problem has been
mentioned already (e.g. topic "conditional formulas" last month appears
relevant)

no = needed :)

On 10 February 2012 23:07, John Machin <sjmac...@lexicon.net> wrote:

--
Craig

()  ascii ribbon campaign - against html mail
/\

and in any case COUNTIFS() is not available in XLS files. To see this for
yourself, fire up Excel 2007 or later, enter a formula with COUNTIFS in it,
and try to Save As Excel 97-2003 Workbook (*.xls)

If the users are not allowed to modify the workbook that you are creating,
you could avoid formulas and calculate the results in Python