Nice easy one that! You were nearly there: ="Number of errors are " & (SUM(A1:A3) &".")
On 5 November 2012 06:06, dave_ <[email protected]> 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: [email protected] > 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: [email protected] 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
