Sum or Sumifs of Values + Percentage in a single cell

[gannybun]

I understand that you can use =concat to combined the text of columnE and columnF
Would like to explore the possibility to see if there a formula to directly present the value in yellow below

thank you very much! please let me know if this is the wrong place to post happy to redirect the enquiry somewhere else

Data pool			Summary using =sumifs
Color	Score			Total	Percent		Present as
Blue	5,000		Blue	13,050	58.7%​		13,050 (58.7%)
Red	3,440		Red	9,170	41.3%​		9,170 (41.3%)
Blue	3,000			22,220	100%​
Blue	5,050
Red	4,500
Red	1,230
Total	22,220

 

[Special-K99]

in H3
=E3&" ("&F3&")"
copy down to H4

Replace E3 and F3 above with the formulas in those cells if you don't want to display E3 and F3

 

[SunnyAlv]

Try This

On cell "H3"

=VSTACK(CONCAT(SUMIF(A3:A9,D3,B3:B9)," (",TEXT(SUMIF(A3:A9,D3,B3:B9)/SUM(B3:B8),"0.0%"),")"),CONCAT(SUMIF(A3:A9,D4,B3:B9)," (",TEXT(SUMIF(A3:A9,D4,B3:B9)/SUM(B3:B8),"0.0%"),")"))

 

[gannybun]

@Special-K99 i wanted a formula to do this. without using column E or F.

@SunnyAlv i will give it a try in a while. can i introduce the thousand format into my value (10,000)? ? so that what is presented is 34,543 (45.3%)

 

[SunnyAlv]

@Special-K99 i wanted a formula to do this. without using column E or F.

This formula does not use Columns E or F, the formula directly refers to Columns A and B as a Table

can i introduce the thousand format into my value (10,000)? ? so that what is presented is 34,543 (45.3%)

Yeah u can try it

 

[gannybun]

=CONCAT(SUMIF(A3:A9,D3,B3:B9)," (",TEXT(SUMIF(A3:A9,D3,B3:B9)/SUM(B3:B8),"0.0%"),")")

do you know how can i add comma in thousands? i cannot seem to get the format right. do i need to Text() the first sumif?

 

[Joe4]

Change this:

"0.0%"

to this to show the comma in the thousands place:

"#,##0.0%"

 

[Joe4]

Sorry, I just realized that you probably want to add the thousands place to the first number, not the second (which is a percentage).
Same concept, but on the first number, i.e.

=CONCAT(TEXT(SUMIF(A3:A9,D3,B3:B9),"#,##0")," (",TEXT(SUMIF(A3:A9,D3,B3:B9)/SUM(B3:B8),"0.0%"),")")

 

[SunnyAlv]

Try This bro @gannybun

I changed the formula a little by adding the "TEXT" formula there
and cell "G3" u can use Unique Formula

=UNIQUE(A3:A8)

on cell "H3"

=VSTACK(
CONCAT(TEXT(SUMIF(A3:A9,G3,B3:B9),"0,000")," (",TEXT(SUMIF(A3:A9,G3,B3:B9)/SUM(B3:B8),"0.0%"),")"),
CONCAT(TEXT(SUMIF(A3:A9,G4,B3:B9),"0,000")," (",TEXT(SUMIF(A3:A9,G4,B3:B9)/SUM(B3:B8),"0.0%"),")"))

 

[Joe4]

SunnyAlv,

I recommend using the "#,##0" format I suggested instead of "0,000", or else you get some funny looking values for numbers under 1,000, i.e.