Hello prholland, On Sat, 4 Jun 2011 02:54:53 -0700 (PDT) (your time) you said:
> In OpenOffice.org and LibreOffice 3.3 if you used =SUM() to find the total > of the numeric values in a row or column where some of the cells were > blank or just text, then it worked! Now I've just opened a spreadsheet > with LibreOffice 3.4 and #VALUE! is appearing everywhere. That's odd. I don't get that. This works for me: A1 is =SUM(A2:A7,B1:G1) A7 is =SUM(52/4) G1 is =SUM(365/52) E1 and A5 are empty A6 and F1 are text A B C D E F G 1 =SUM() 1 2 3 TEST =SUM() 2 1 3 2 4 3 5 6 TEST 7 =SUM() -- Si (PLO) #27176. Do Gee Owns Whir? ¶ Auxiliary Information: • LibreOffice 3.4.0 OOO340m1 (Build:12) • Windows XP Pro 5.1.2600 Service Pack 3 -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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
