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
Calculating an Earlier Sum Based off Multiple Criteria
Hello, I am currently trying to pull last month's total for a certain line item that has the following criteria: -Project -Cost Code -Amount Example of the columns would be: Month Project Cost Code Amount 9/1/2022 3704 250 $10,700 9/1/2022 3704 280 $7,800 10/1/2022 3704 250 $11,200 What I would need the measure to do, is figure out the what the sum is of the earlier amount by Project & Cost Code, referencing the Month column. Mind you there are multiple Projects & an abundance of Cost Codes. So simply having it Filter just for Project 3704 & Cost Code 250 wont work. It needs to be able to find the earlier amount for each item, if there isn't an earlier amount then output 0. Will truly appreciate any help on this, been stuck for quite some time.