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
|