Concatenate w/ Sumifs format

  • Thread starter Thread starter MAXWELL
  • Start date Start date
M

MAXWELL

I am trying to concatenate two numbers into one cell.

In the formula, I concatenate two 'SUMIF' statements to
show how many units were sold and the dollars.
It looks like this now... (5000 / $100000)

It looks OK but I want to put in commas to look like
this...
(5,000 / $100,000)

I can't figure how I can get the commas in there...

How do I do this...
 
Hi
try something like
="( " & TEXT(SUMIF(...),"0,0") & " / " & TEXT(SUMIF
(...),"$ 0,0")
 
Hi Maxwell

this can be achieved along the following lines
=CONCATENATE(TEXT(SUMIF(C2:C17,"A",B2:B17), "#,###"), " / ",
TEXT(SUMIF(C2:C17, "B",B2:B17),"$#,###"))
OR
=TEXT(SUMIF(C2:C17,"A",B2:B17), "#,###")& " / "& TEXT(SUMIF(C2:C17,
"B",B2:B17),"$#,###")

Cheers
JulieD
 
MAXWELL wrote...
...
In the formula, I concatenate two 'SUMIF' statements to show
how many units were sold and the dollars. It looks like this
now... (5000 / $100000)

It looks OK but I want to put in commas to look like this...
(5,000 / $100,000)
Click to expand...
...

="("&TEXT(SUMIF(foo,onething),"#,##0")&" / "
&TEXT(SUMIF(bar,andanother),"#,##0")&")
 
Back
Top