Summing in a sentance...

[Jay]

Hello,

If cells A1 & B1 represent Apples.

A1 = 10
B1 = 10

C1 = "There are 20 apples total"

What is the formula to have my answer (20) appear within a
sentance?

Thank you,
Jay Gustafson

 

[JulieD]

Hi Jay

in C1
="There are " & a1+b1 & " apples total"
or
=CONCATENATE("There are ",A1+B1," apples total")

Cheers
JulieD

 

[Dave R.]

="There are "&A1+B1&" apples total."

 

[Guest]

Thanks for replying to my post. But unfortunatly, I
should have given more of the true example. How do I use
your example below, but with the sum function "sum(A1:B1)"

 

[Andy B]

Hi

Just replace the A+B with SUM(A1:B1)

 

[JulieD]

Hi

you don't need to use the sum function
=sum(A1:B1)
is exactly the same (only more typing) than
=A1+B1

but if you really, really want to do this then
=There are "&sum(A1:B1)&" apples total."
or
=CONCATENATE("There are ",sum(A1:B1)," apples total")

Cheers
JulieD