Eagerness to "wage war" makes one sloppy.
It would have been a good advice to posit:
Custom format the column in which you enter the rainfall readings as
[<=0.8]"*"0.0;General
and you will be able to use the ordinary SUM worksheet function.
But, not as custom format cell by cell, abusing user time:
"*"0.0
or the whole column unless one wants the whole column to show stars preceeding all numbers.
A side note. Why didn't I suggest this in my first reply? The rule I follow if it matters to know: Accept the user's routines (in tis case) of data entry if that does not conflict with the proccessing requirements. The cost of a single cell array-formula to sum starred and unstarred entries is definitely a "quantitée négligeable" set off against breaking a user routine. This consideration shows up clearly when users insist of entering (start and end) times as 2245, 0300, etc. instead of 22:45, 03:00, etc.
Aladin
This message was edited by Aladin Akyurek on 2002-03-24 01:40