Hi Excel Fans,
I have been racking my brain probably for an easy formula, which I can't get to work. I'm looking for a formula that will give me the percent for each item based on Totals, the caveat is let's say someone manually makes an adjustment to the value column, i want to now only account for the cells that have formulas only. Hence my new Output column. Anyone that could help would be greatly appreciated.
I have been racking my brain probably for an easy formula, which I can't get to work. I'm looking for a formula that will give me the percent for each item based on Totals, the caveat is let's say someone manually makes an adjustment to the value column, i want to now only account for the cells that have formulas only. Hence my new Output column. Anyone that could help would be greatly appreciated.
Value | Regular Output % | New Output | Notes |
40 | 26.7% | 0% | 40 is a manual Input |
50 | 33.3% | 45.5% | 50 is formula |
60 | 40% | 54.5% | 60 is a formula |
Total 150 | 100% | 100% |