Multiple employees average percentage weekly, monthly, quarterly
I have 10 employees and need to calculate their average percentage weekly, monthly and quarterly. For Example: Joe Column/row C1 Sam Column/row D1 Greg Column/row E1 1st week row 2 2nd week row 2 3rd week row 4 4th week row 5 This will continue to row 52 I have a another column January Column T Feburary Column U March Column V Quarterly Column W Joe =average(C2:C5) on cell T2, =average(C6:C9) U2 =average(C10:13) V2 This gives me the percentage for weeks 1-4 month of January How do I create a formula for Sam (D2:D5) in T3 and Greg (E2:E5) in T4 and for the rest of the multiple employees without having to manually enter the formula for each cell. This we’ll be for the entire year, 52 weeks for each employee. I tried everything to copy paste formula, drag cell, etc but gives me the same results of only Cell C2:C5, C6:C9, etc. Any help will be great. I have been researching testing and nothing is working. TIA AverageAsker arvindsingh802