L
Legacy 301846
Guest
In tracking financial data on a monthly basis, I calculate a % of the total each month. How can I get the formula to automatically change when I enter the next month's data?
Example:
Col A are the factory sites (A2=1, A3=2, A3=3)
Col B thru M are the months of the Year (Jan - Dec)
Col N is the % of total that each month's data represents at each site
Cell A8 is the total used to calculate the %
A8=600,000
B2=60,000 for January
N2=10% (B2 / A8)
When I enter February data into cell C2, I want N2 to automatically update with the new %.
Example:
Col A are the factory sites (A2=1, A3=2, A3=3)
Col B thru M are the months of the Year (Jan - Dec)
Col N is the % of total that each month's data represents at each site
Cell A8 is the total used to calculate the %
A8=600,000
B2=60,000 for January
N2=10% (B2 / A8)
When I enter February data into cell C2, I want N2 to automatically update with the new %.