Percentage calculations from an unsorted two column list

[Rokuro kubi]

A and B columns are both sourced with data from another worksheet - A
is always a 2 letter code, eg. "Re" or "Ca", and B is always a numeric.
I want to keep the workbook macro-free so without using macros to sort
or subtotal the columns first, how can I calculate the percentages of
each code's numerics, so I can present these on another sheet?

 

[Rokuro kubi]

A and B columns are both sourced with data from another worksheet - A
is always a 2 letter code, eg. "Re" or "Ca", and B is always a numeric.
I want to keep the workbook macro-free so without using macros to sort
or subtotal the columns first, how can I calculate the percentages of
each code's numerics, so I can present these on another sheet?

OK I got it - this is what SUMIF is made for.

 

[Mallycat]

You could try using =sumif to sum all the totals for each type

 

[Rokuro kubi]

You could try using =sumif to sum all the totals for each type.

I think you must have sent it to me telepathically first LOL

Works perfectly, cheers