Created attachment 23508 [details]
workbook containing the scenario described

I've got a named range in my Excel sheet: 
Is_Multicar_Vehicle(='Veh Applicability'!$B$17:$G$17) i.e the above named range refers to cells from B17 to G17 in another sheet named "Veh Applicability".

Now I've the following formula in a cell C19 of sheet named "Input".
=SUM(Is_Multicar_Vehicle)

The following is the code snippet used to evaluate the above cell
			HSSFCell cell1 =  workbook.getSheet("Input").getRow(18).getCell(2);
			CellValue MultipleCarIndicator1 =  hsf.evaluate(cell1);
			

When I try to evalute the above cell, I am getting the below exception
Exception in thread "main" java.lang.RuntimeException: Don't now how to evalate name 'Is_Multicar_Vehicle'
	at org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:439)
	at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:334)
	at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:216)
	at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:180)
	at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:297)
	at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:159)
	
I'm attaching the excel sheet used.
I've used both POI 3.2 final and the 3.5beta5 release.
Please fix this issue. I am very much in need of this.

Regards,
Kiran Sireesh