How to add comma to my concatenate formula?

[wmichael]

Hello. I am seeking how to add a comma to this formula
{=CONCATENATE("and ",SUM(S2:S500)," in total Media Value")}
so that a comma separates the thousands place in this result
{and 1862943 in total Media Value}
Thank you in advance for your help on this.

 

[Fluff]

How about
=CONCATENATE("and ",TEXT(SUM(S2:S500),"#,##0")," in total Media Value")

 

[wmichael]

Answered my question- you've been very helpful- thank you!

 

[Fluff]

You're welcome & thanks for the feedback

 

[Rick Rothstein]

How about
=CONCATENATE("and ",TEXT(SUM(S2:S500),"#,##0")," in total Media Value")

Using Fluff's TEXT function call allows you to embed the text being concatenated directly into the format pattern and eliminate the CONCATENATION function entirely...

=TEXT(SUM(S2:S500),"""and ""#,##0"" in total Media Value""")