Astrid has attended:
Excel Advanced - Formulas & Functions course
Formula
I have calculated the average % of business per weekday as follows:
Monday 12%
Tuesday 20%
Wednesday18%
Thursday 16%
Friday 13%
Saturday 11%
Sunday 10%
I have a total for each week, eg. Monday 6th Jan to Sunday 12th Jan the total is 3138 (100%).
How do I write a formula to calculate the % for each day against the total of the week?
Thank you!
PS: I can do a simple mulitplication for each week but was wondering if there's a formula I can use to populate the figures for the whole year as I have so many to do...
RE: Formula
Hi Astrid
Thanks for getting in touch. I think I'm missing something - have you not already calculated what the % of the week's total is? e.g. 12% is Monday's percentage?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Formula
Hi Gary,
Yes, I already have the % averages for each day (as for this example)
Monday 12%
Tuesday 20%
Wednesday18%
Thursday 16%
Friday 13%
Saturday 11%
Sunday 10%
I also have a total for each week.
Problem is that there is a different total for each week so I can't see how I can do a formula to copy through all 52 weeks? It seems I have to absolute each total per week?
RE: Formula
Hi Astrid
I guess this depends on the layout of your data. If your data is in uninterrupted blocks you'll be able to drag the formula across.
Remember how we looked at 'mixed' references? e.g. you can have E5, $E$5, $E5 or E$5. Does this help?
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
