auto fill percentage

[Quicksnot]

Hi everyone

looking to find a formula that will add a percentage in B2 on my chart that will automatically change when I add numbers in by the week.

Thanks
Keith

[FDibbins]

I think youi mean average, not percent?

Try this...
=AVERAGE(E2:T2)

[Quicksnot]

yea sorry, but as I add in numbers every week, it needs to be divided by the number of weeks, if I write in a number for week 4 then it has to take a total of all 4 weeks and divide it by 4 and so on, is there a way it can do it by a formula?

Thanks
Keith

[shukla.ankur281190]

Average function will do the same thing Keith, when you will add number for next week Average function will instantly understand now it would have to add the numbers and then divide count of numbers.