the situation is this.. I have an example: column a1 thru a12 have ach months sales for the year of 2003. column b1 thru b12 have the sales for each month in the year 2002. I need to find a calculation to show percentage of gain or loss for each month in the year in column c1 thru 12 and total year gain and loss percentage in c13
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
gains and losses
- Thread starter pitagal
- Start date
Pitagal,
Further to John's solution,
To show the total in C13, you'll need
=(SUM(B1:B12)/SUM(A1:A12))*100
Leigh Moore
LJM Analysis Ltd
Further to John's solution,
To show the total in C13, you'll need
=(SUM(B1:B12)/SUM(A1:A12))*100
Leigh Moore
LJM Analysis Ltd
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question