Percentage calculations from an unsorted two column list

  • Thread starter Thread starter Rokuro kubi
  • Start date Start date
R

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 said:
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?
Click to expand...

OK I got it - this is what SUMIF is made for.
 
Mallycat said:
You could try using =sumif to sum all the totals for each type.
Click to expand...

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

Works perfectly, cheers
 
Back
Top