Nice easy one that! You were nearly there: ="Number of errors are " & (SUM(A1:A3) &".") On 5 November 2012 06:06, dave_ <dave.wagner08@gmail.com> wrote:
Is it possble to do the following: Lets say a1 =5, a2=3 and a3=7, now in cell c1 I would like a message to say "Number of errors are " + (=sum(a1:a3) +"." Number of errors are 15. Is this even possible? Thanks ahead for any suggestions. -- View this message in context: http://nabble.documentfoundation.org/Is-it-possible-to-show-cell-value-with-text-tp4016842.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted