If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...

Have you ever thought of the humble SUM function as a secret weapon for advanced analytics? Most Excel users see it as a basic tool for adding numbers, but what if I told you it could do so much more?

For novices, functions are one of the most intimidating features of OpenOffice.org's Calc. Newcomers quickly learn that functions are a main feature of spreadsheets, but there are almost four hundred, ...