Question
quarterly market share calculation
I have a simple sales production worksheet created in Adobe Acrobat 9
with 4 quarterly sales figures in a fillable column, (A1,B1,C1,D1) and a sum total E. I want to calculate the market share of each quarter in the year as a percentage in the next column(A2-D2) with E2=100%. It's a simple equation in Excel, but I'm not having any luck in creating the Javascript formula to render a result.
Any assistance greatly appreciated!
| Sales Revenue | Quarter% |
|---|---|
| A1 | A2=% A1 of total Revenue |
| B1 | B2=% B1 of total Revenue |
| C1 | C2=% C1 of total Revenue |
| D1 | D2=% D1 of total Revenue |
| E1=Total of Column 1 | E2=100% |
AdChoices