Excel Expert for average formula issue
$10-30 USD
Betalt ved levering
Hi I'm trying to find an average that updates weekly based on input in specific columns and an allotted amount of hours.
The average should be equivalent across all 13 weeks when started. (This will be replicated 4x once for each quarter). Once hours are inputted into ANY Week's USED column, the average availability columns without any hours inputted into the used columns, is updated accordingly based on remaining weeks and remaining total hours.
For Example If Allotted hours for the quarter is 1300, week 1 uses 100 hours, then the hours should still be 100 for the next 12 weeks. However if you put in a 0 or any other # into used hours for weeks 2-13, the average available will get updated to show an updated # for each week.
I tried some formulas attached but nothing was coming out correctly to even start me off.
Thanks
Projekt ID: #16343294
Om projektet
14 freelancere byder i gennemsnit $24 timen for dette job
Good morning, I am Luis and it will be my pleasure to help you with this Excel project. I can figure out how to help you with your issue. Please contact me by chat and then we could discuss better your project! Ki Flere
Hi, i would like to help you with the formulas on the excel spreadsheet. i am very well versed in Excel. Looking forward to be working with you.
Hi there: Being an expert in Excel, i am offering my services. I am university qualified person having 10 years working experience in Excel. I will resolve your issue in using average formula in Excel. You will b Flere
Hi the task is a simple one. Will be done based on conditional statements. Your task is fully understood. I have 10 years of advance excel experience. Looking forward to hear from you
Understand the requirement and can complete the same in one day, Looking forward to hear from you. Sometimes excel formulas looks complex but they are not :-)