Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions |