Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Cumulative share
Hello :)
I would like to create a formula that adds the share of an item with the shares of all other items ranked higher. In the data below, I have labeled what the formula would output as cumulative share. The cumulative share of Item C would be the combined share of Item C, B, and A. Currently, to find cumulative share I sort by rank and sum all shares, however I would like a formula returns this answer without sorting. Can be done with a SUMIF function? Any ideas? Thanks! Ranking Share Cumulative Share Item C 3 18% 73% Item B 2 24% 55% Item E 5 12% 100% Item A 1 31% 31% Item D 4 15% 88% |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Cumulative share
With your data in C5:D100 (rank and share)... Enter in E5 and fill down... =SUMIF($C$5:$C$100,"<="&C5,$D$5:$D$100) -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Reagan" wrote in message Hello :) I would like to create a formula that adds the share of an item with the shares of all other items ranked higher. In the data below, I have labeled what the formula would output as cumulative share. The cumulative share of Item C would be the combined share of Item C, B, and A. Currently, to find cumulative share I sort by rank and sum all shares, however I would like a formula returns this answer without sorting. Can be done with a SUMIF function? Any ideas? Thanks! Ranking Share Cumulative Share Item C 3 18% 73% Item B 2 24% 55% Item E 5 12% 100% Item A 1 31% 31% Item D 4 15% 88% |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Cumulative share
VERY helpful. Thank you.
"Jim Cone" wrote: With your data in C5:D100 (rank and share)... Enter in E5 and fill down... =SUMIF($C$5:$C$100,"<="&C5,$D$5:$D$100) -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Reagan" wrote in message Hello :) I would like to create a formula that adds the share of an item with the shares of all other items ranked higher. In the data below, I have labeled what the formula would output as cumulative share. The cumulative share of Item C would be the combined share of Item C, B, and A. Currently, to find cumulative share I sort by rank and sum all shares, however I would like a formula returns this answer without sorting. Can be done with a SUMIF function? Any ideas? Thanks! Ranking Share Cumulative Share Item C 3 18% 73% Item B 2 24% 55% Item E 5 12% 100% Item A 1 31% 31% Item D 4 15% 88% |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CUMULATIVE TOTALS | Excel Discussion (Misc queries) | |||
Cumulative Hours | Excel Discussion (Misc queries) | |||
Can't share workbook. The "Share Workbook" option is off. Why? | Excel Discussion (Misc queries) | |||
How to Share & "Un-Share" Worksheets | Excel Worksheet Functions | |||
Cumulative Sum | Excel Worksheet Functions |