Problems with calculating percentages on any given day! please help!!

[damo2deme2]

Hi, I have a problem that is probably really easy to solve but my brain isnt working today, i wondered if someone with a bit of intelligence could help me out????

On the perfromance data tab i have the Week To Date Despatch Time Performance section. It adds the percentage and creates a percentage up over the week but if one day isnt complete it doesnt calculate. i would like it to be culmunative, so it creates a percentage no matter what info is filled in, does that make sence?

I would be really greatful if someone could help me out.

This is concerning cells: C33 for the average and sunday to Satruday: C22,F22,I22,L22,O22,R22,U22

Thank you

[judgeh59]

give this a look.....I used ISERR which I believe should work for you....IFERROR is the 2007-2010 version, hopefully this should work....

[damo2deme2]

Thanks so much for working on this but if the Sunday percentage reads 100% the week to date should read 100%, as to that point we have hit our despatch times 100%. So for example if sunday and monday read 100% then the week to date should still read 100%.

Does that make sence? Thank you again for working on this, much appreciated

[judgeh59]

I think so...but I'm out for the rest of the day....can you fill in the saturday data so I don't have to go through and reverse engineer the data?....I'll take a look at it if nobody else has helped by then....

[Cerbera]

Hi,

You can change each of the day formulas from:

=IF(ISERR(Sunday!$O$16),0,Sunday!$O$16)

To

=IF(ISERR(Sunday!$O$16),"",Sunday!$O$16)


Then change the Week to Date formula to:

=SUM(IF(ISERROR(C22:U22),"",C22:U22))/COUNT(C22:U22)

Should work fine

[dlow]

Im a novice, but could it be how you calculating you %s I do it like this:

Please Login or Register  to view this content.

Hi

I cant get that to work, could you have a go and send it me?? Thank you!!!!!!

I dont know what doesnt work & who you're asking for help, but anyway if its me, Im not much help. I am just showing you that to calculate %s I use the ABS Function its easy enough give it a google search, something like Excel formula calculating percent ABS Function
I did it just to check & its the 1st result. Anyway I looked @ your workBook & it too complicate for me Im not that smart. Good Luck.

[damo2deme2]

Hi

I cant get that to work, could you have a go and send it me?? Thank you!!!!!!

[damo2deme2]

It was directed at anyone who can help, thing is im at work and i havent got time to look things up, im not being lazy, i have tried to do this myself and failed haha!

It needs to be complete by the end of my shift and im worried that i wont get it finished in time.

Thanks for everyones input, never known so many helpful people.

[Cerbera]

Hi,

I've attached a copy of the sheet with the formulas in (note I did remove the formatting so you'll have to copy the formulas or reformat).

Hope that this helps.

If so please click on the *Add Reputation and close the thread under "Thread Tools" at the top.

Cheers,

Cerbera

Cardinal_Tracker.xls