I have a spreadsheet where I am entering 3 elements of wages (basic, holidays, overtime) then totalling the gross pay for each week then again over a period of 13 weeks. I need to average what each person earned per week. However not everyone worked all 13 weeks so I want to count how many weeks they worked and use that in a new formula. The COUNT function doesn’t like me clicking on the totals for each week to work out the average. I don’t really want to do this manually as there are over 150 employees. Any tips please?

​I have a spreadsheet where I am entering 3 elements of wages (basic, holidays, overtime) then totalling the gross pay for each week then again over a period of 13 weeks. I need to average what each person earned per week. However not everyone worked all 13 weeks so I want to count how many weeks they worked and use that in a new formula. The COUNT function doesn’t like me clicking on the totals for each week to work out the average. I don’t really want to do this manually as there are over 150 employees. Any tips please?  Read More

​