Percentage calculations from an unsorted two column list
 

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?

Percentage calculations from an unsorted two column list
 

Rokuro kubi wrote:
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.

Percentage calculations from an unsorted two column list
 

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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561674

Percentage calculations from an unsorted two column list
 

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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=561674

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

Works perfectly, cheers