On 7 Jun 2008 at 17:52, Richard Detwiler wrote: > mike scott wrote: ... > > try filling a1:a10 with a 1. Then somewhere put a cell with > > counta(a1:a10) and another with sum(a1:a10). Now try (1) clearing, > > say, a5, and (2) putting an unquoted space in a5. Now suppose > > someone is doing some sort of stats with those numbers. I see scope > > for well-disguised problems. > > > > Holy cow, you seem to be going to great lengths to contrive problems. > > First of all, if someone wants to count how many numbers are in a range, > use COUNT (which counts only numbers), not COUNTA (which counts both > numbers and text entries). I don't see how anyone would set up a formula > COUNTA if he/she just wants to count the numbers in a range. (And then > be surprised when it counted a text entry.)
Would you believe I'd blanked out the difference between count() and counta()? I've certainly read the words, but...... Anyway, thanks all; I'll find a comfy corner to slink into....... -- Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED] Mike Scott, Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
