Sounds like you are having a column with Subtotals and Grand Totals. The SUM function that yields your grand total does not need to pick out ranges. Just run the SUM function over the entire column
For example A B 1 Supplier #1 1.00 2 2.00 3 Subtotal @SUM(B1:B2) 4 Supplier #2 3.00 5 4.00 6 Subtotal @SUM(B4:B5) 7 GRAND TOTAL @SUM(B1:B5) You would think that the GRAND TOTAL would be double the correct result, because it looks like the formula includes the subtotals at B3 and B6. But such is not the case. The SUM function will ignore cells which contain subtotals from cells already included in the SUM. I'm not sure that the POI Formula Evaluator behaves this way. But Excel does. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
