How to add comma in multiple formula formatting using CountIf / Round / Sum

[sanfrancisco]

I have a sheet that I'm trying to add commas to the final output formatting. If I use just the basic function Rount(Sum(D1:D8),) the output shows the final number formatted correctly. I am also trying to aggregate another row together with this and show a total count of the number of units based on CountIf and the text such as CountIf(B1:B8,"*Sold*". When combining these together the output shows this:

$8888 (8)

I need the output to show the first number that's been returned with commas: $8,888 (4)

Formula ="$"&ROUND(SUM(D1:D8,)&" ("&COUNTIF(B1:B8,"*Sold*")&")"

 

[SanjayGMusafir]

I need the output to show the first number that's been returned with commas: $8,888 (4)

Use this -

="$"&Text(ROUND(SUM(D1:D8,),"#,###")&" ("&COUNTIF(B1:B8,"*Sold*")&")"

 

[sanfrancisco]

Use this -

="$"&Text(ROUND(SUM(D1:D8,),"#,###")&" ("&COUNTIF(B1:B8,"*Sold*")&")"

Is the Text function wrapping around the entire formula? There's a missing ) somewhere as I'm getting an error

 

[SanjayGMusafir]

Actually I copied pasted your formula which already carried an error. Try this -

="$" & Text(ROUND(SUM(D1:D8),0)"#,###") &" ("& COUNTIF(B1:B8,"*Sold*") &")"

 

[SanjayGMusafir]

Still there was some error -

Use this -

="$" & TEXT(ROUND(SUM(D1:D8),0),"#,###") &" ("& COUNTIF(B1:B8,"*Sold*") &")"

 

[sanfrancisco]

Still there was some error -

Use this -

="$" & TEXT(ROUND(SUM(D1:D8),0),"#,###") &" ("& COUNTIF(B1:B8,"*Sold*") &")"

Works like a charm. Thank you!

 

[SanjayGMusafir]

Glad to help you