I suppose there is no way to change the whole spreadsheet design? It doesn't seem to be very well designed if you need a SUM() function that need more than 30 different entries.
I see it there are at least three ways that I would have tried: 1. Redesign the whole spreadsheet 2. Use several cell to sum parts of the whole spreadsheet, like: T328: =SUM(C45; D32; E1204; …) T239: =SUM(F132; G100; …) T240: =SUM(GT65535; AA10000; B1; …) And so on… Then: T1000: SUM(T328:T999) 3. Make your own SUM function "MYSUM" (using StarBasic, for example) that fills your needs and use it instead of the built in SUM function. Anyway, without having seen the actual spreadsheet, it feels like it's not optimal in design. By the way, I just found a fourth possible workaround for your problem: 4. Create a new spreadsheet, (which you can hide later I think). Let's say that your original sheet use the following cells that you want to use the SUM function for: A34 B45 G312 C3 …etc, maybe about 200 cells or so. In the new sheet, write the following formulas in A1 until Ax: A1: =TheOriginalSheet.A34 A2: =TheOriginalSheet.B45 A3: =TheOriginalSheet.G312 A4: =TheOriginalSheet.C3 …and so on for the rest of the cells. In the cell of the original shhet where you want your sum to appear, write: =SUM(TheNewSheet.A1:A200). Of course type the real names of your sheets instead of "TheOriginalSheet" and "TheNewSheet" respectively. I am not sure I understand the problem, but at least I tried. Johnny Andersson
