Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formula

ResolvedVersion 2010
Edited on Mon 2 Dec 2013, 09:35

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

RE: Formula

Doh! Didn't think of that.

Thanks Gary,
Astrid

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.