Ver 4.3.7.2 EN Calc Formula SUM now gives a answer #VALUE!

[eatonconstruct]

My formula {=SUM((allo=A8)8(amount))} now gives the result #VALUE!
This formula has worked since I converted to LibreOffice from Lotus 123 in 2011.
allo is a name range in a column which is the allocation of costcode (an integer) on sheet 1.
amount is a name range in the susequent column which is the allocation of purchase cost (numeric to 2 decimal places) on the same sheet 1.
On sheet 2 , sheet 3, and more sheets I use the above formula {=SUM((allo=A8)8(amount))} to total all the costs associated with the cost code which is found in cell A8 which have been captured on sheet 1.

Please help?
LibreOffice Ver 4.3.7.2 English Spreadsheet
Windows 8.1 Pro

[Lupp]

Are you sure the 8 in the middle of your code is correct? I would expect a * there. On an US keyboard the * is entered by the keys SHIFT+8 .

[Lupp]

I personally prefer telling any software explicitly what I want to have done. Therefore I never use the feature to automatically “recognise” a piece of text as being meant to name a range. A short test I just made seems to show that the feature is actually broken in V 4.4.3.

Naming ranges explicitly with the meaning of your “allo” (which I suppose to be texts) and “amount” which I suppose to be numbers will make your (corrected by * instead of 8) formula well working. I would prefer to use

=SUMPRODUCT((allo=A8);amount)

because the SUMPRODUCT function will handle the thing as an array formula without further measures.