Closed

Excel Expert for average formula issue

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

Skills: Excel

See more: excel formula download, important excel formulas pdf, advanced excel formulas with examples in excel sheet free download, best excel formulas with examples, average formula in math, excel average formula, average formula in excel 2013, averageif function in excel, buy excel expert, freelance statistician excel expert, excel expert service, excel expert job, excel expert finance job, excel expert independent contractor bid, excel expert salary

About the Employer:
( 0 reviews ) United States

Project ID: #16343294

16 freelancers are bidding on average $25 for this job

expertatwork

Please share your current excel file, I will write the formulas. Thank you!

$39 USD in 1 day
(140 Reviews)
5.8
beltran0404

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 More

$30 USD in 1 day
(73 Reviews)
4.9
AhmedMarzoq

A proposal has not yet been provided

$30 USD in 2 days
(17 Reviews)
4.6
massm90s

Hi there, I'm an Excel expert. My reviews can confirm that. I couldn't fully understand your request. I can start work on it right away, before being awarded. I just need to see the file, maybe it'll help. Drop More

$20 USD in 1 day
(21 Reviews)
4.1
ongskjason

A proposal has not yet been provided

$30 USD in 1 day
(4 Reviews)
3.4
supergana

Hi - The excel sheet is not attached. What you are saying is possible with array formulas. Or to simplify we need to break the formula into 2/3 pieces in different cells and achieve same . Let me know the details an More

$30 USD in 1 day
(3 Reviews)
2.9
$10 USD in 0 days
(10 Reviews)
2.7
RenPerera

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.

$10 USD in 1 day
(3 Reviews)
2.8
haleem0786

I can do [login to view URL] review my profile and inbox me.i have good command over ms excel, thanks Relevant Skills and Experience Excel

$23 USD in 1 day
(6 Reviews)
2.7
imranrazawi

I am experienced Excel VBA developer. I have developed many Excel formulas for Average sum and other data analytical solutions in past.

$25 USD in 1 day
(2 Reviews)
2.2
jawadrafia

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 More

$30 USD in 1 day
(3 Reviews)
2.5
sabahuddin1234

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

$10 USD in 2 days
(4 Reviews)
2.1
lherreraz

I have a large experience working with advanced Excel and Macros using VB, the most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your pro More

$20 USD in 3 days
(4 Reviews)
1.4
sunprah2018

I am an MBA, and ex-investment banker. I assure all my clients a high quality work in a stipulated time period. My skill set includes the following: 1. Excel 2. Financial Modelling 3. PowerPoint Presentation 4. M More

$50 USD in 1 day
(1 Review)
1.2
$23 USD in 1 day
(1 Review)
0.8
Ranjan2201

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 :-)

$25 USD in 1 day
(0 Reviews)
0.0