averages

[Pam]

sample of sheet

colA B C D E F G
Mon Tues Wed Thurs Fri Avg
row 2: week1 5 8 4 3 7 5.4
row 3: week2 14 5 8 2 3 6.4
row 4: week3 5 6 8 2 3 7.6
row 5: week4 8 1 2 3 5 3.8
row 6:......... TOTAL MONTHLY AVERAGE 5.8

question: I need to show a percentage of increase or
decease of the weekly total averages in col H.

I was given the formula to put in col H: =((g3-g2)/g2)and
when I copy it down what do I use in the formula for g5
(the next row down is the total average)? I am very
confused.

 

[Don]

Hi Pam,

I gave you that formula and it does work. If you'd like,
send me a copy of your sheet and I'll take a look and see
what the problem is. Just remove the spam out of the
email above.

Have a great day,

Don