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

 

[SunnyAlv]

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.

View attachment 104767

yes you're right, I just thought that the number in question was thousands so I made it like that and didn't think about whether the number was tens to ones

 

[gannybun]

thank you everyone. certain percentage of my salary belong to this platform. life savers!

 

[gannybun]

just another question, is there a way to tweak the formula to show the percentage or value in another color?
etc. Black for Value and Yellow for pencentage.

 

[Joe4]

just another question, is there a way to tweak the formula to show the percentage or value in another color?
etc. Black for Value and Yellow for pencentage.

Not without VBA.
Formulas can only return values, not formatting.
And Conditional Formatting is applied to the whole cell, not parts of it.