How do I get a SUM function in a ClarisWorks spreadsheet to exclude the lowest number in a range of numbers from the total and we don't know which cell it will be in?
Answer: After creating the SUM formula,
1) Precede the lowest number with an option space character
OR (even better )
use =SUM(C1..C20)-MIN(C1..C20).