Need Help finding Average if specific employees have hours

Hello there,

I am trying to find an average of hourly rates in our excel file as long as the employee is working. We have all the phases of our projects and disburse hours, but not everone on staff is on that project, so is it possible to have excel check if there's any value in a range of cells in a row, if so, that then adds the person hourly salary to the average calculation?

Does that make sense?

I have attached a simple example which should clear it up.

Thanks,
Lorne

Ok playing with it more and got this formula to work (after pressing ctrl + shift + enter):

Please Login or Register  to view this content.

However, now I'd love to take the average based on the percantage the employee is working in the overall project hours? Am I getting to complicated now?

Your CSE formula can be replaced with this:

=AVERAGEIF(B11:E11,">0",B3:E3)

and I don't know what you mean by your last question

Sorry Ice, should have refreshed before posting

Well I would love to have the average weighted based on percentage.

So based on my attachment above employee 1 = 81%, 2=0%, 3=13%, 4=6% of the overall hours worked.

Is it possible to have the average hourly rate calculated with the weighted percentages? I really have no idea where to start on this one.