Can I just ask what you expect that SUM() formula to produce. Using the colon separator seems to indicate that you are trying to sum the cells between one named area and another one, an analogue for SUM(A1:A35), where the named areas refer to single cells. If you want to sum the cells in two different named areas, should not the formula look something like this SUM(Sheet1!Area1, Sheet1!Area2) ?
That may not be the cause of the problem of course but I do wonder if the formula parser is objecting to the use of the colon in this specific case. Could you try replacing the colon with a comma in the example you gave to see what the results of this are please? -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Parse-intersecting-name-ranges-tp5712565p5712571.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
