View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
IanC[_2_] IanC[_2_] is offline
external usenet poster
 
Posts: 157
Default Adding text to the start of a formula

Just get rid of the ",=" before SUM.

=B2 & " sold " & SUM(D8:D20)

The spaces I've added aren't strictly necessary, but makes it easier to
read.

--
Ian
--
"Joel" wrote in message
...
Hi I am trying to add text to the start of a forumula without success
below
is what I am trying to use. Please help

Joel

=B2&"sold "&,=sum(D8:D20)
--
N/A