Michael D. Setzer II wrote: > > If you use count on a range it only counts numeric cells, but > counta counts numeric and non-empty cells, so if they don't give > the same results for the same range, there is an error? >
Yes, that would work but it forces me to do this verification for each column. And still it won't tell me where the error is (although I can find it with some filters) It would be much better if there was some AI in these functions warning me that "Data in Cell A12345 is not a number. What do you want to do? A) Jump to cell A12345 and manually fix it or B) Ignore this warning and Sum all other cells?" Why not use the computing power of the PC to help us? -- View this message in context: http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3023698.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted