Combine Text with numbers driven from a formula, and include a comma

I am trying to figure out how to combine text with numbers that were generated from a formula. I am successful in making it happen, except I can't get the number to include a comma separator. Any suggestions?

="Total Sets Forecast"&":"&" "&SUM(E5:P5)
Result is: Total Sets Forecast: 22268
I am wanting the result to be: Total Sets Forecast: 22,268

I have another one with a bit more complicated formulas as shown below. Same issue applies.
="Current Inventory"&":"&" "&SUMPRODUCT(($D$9:$D$170)*(LEFT(A9:A$170,LEN(E$2))=E$2))
Result is: Current Inventory: 22000
I am wanting the result to be: Current Inventory: 22,000

Thanks in advance.

example:
="Total: "&TEXT(SUM(N17:N19),"#,##0.00")

Thank you. The suggestion worked great for the first one but not the second. I tried to add the number signs in the sequence you suggested as shown below:


="Current Inventory"&":"&" "&SUMPRODUCT(($D$9:$D$170)*(LEFT(A9:A$170,LEN(E$2))=E$2)),"##,###")

Unfortunately I got an error message that said:

The formula you typed contains an error.
• To get assistance in entering a function, click OK,then click Function on the Insert menu.
• If you are not trying to enter a formula, avoid using an equal sign (=) or minus sign (-), or precede it with a single quotation mark (').

Thanks in advance.

="Current Inventory"&":"&" "&TEXT(SUMPRODUCT(($D$9:$D$170)*(LEFT(A9:A$170,LEN(E$2))=E$2)),"#,##0.00")

This worked Great for both. Thanks!

Ford, I just copied his formula, add TEXT and that's all. Do you see breaking text in my previous post?