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