May not be possible...

%3CLINGO-SUB%20id%3D%22lingo-sub-1835174%22%20slang%3D%22en-US%22%3EMay%20not%20be%20possible...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835174%22%20slang%3D%22en-US%22%3EOk%2C%20bare%20with%20me%20as%20i%20may%20not%20explain%20this%20very%20well%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20the%20very%20basic%20picture%20i%20have%203%20seperate%20values%20for%20which%20i%20want%20the%20averages%20for%2C%20however%20i%20want%20them%20for%20the%20different%20Managers%20above%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20instance%20if%20Terry%20runs%20Friday%20and%20Saturday%20i%20woukd%20like%20to%20know%20his%20average%20result%20for%20all%20Values%2C%20and%20for%20that%20result%20to%20go%20into%20a%20seperate%20table%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20the%20shift%20managers%20will%20change%20every%20week%20(for%20which%20id%20use%20a%20seperate%20tab)%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20it%20possible%20and%20have%20i%20made%20myself%20clear%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1835174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1835193%22%20slang%3D%22en-US%22%3ERe%3A%20May%20not%20be%20possible...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835193%22%20slang%3D%22en-US%22%3EAttachment%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1840656%22%20slang%3D%22en-US%22%3ERe%3A%20May%20not%20be%20possible...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1840656%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F851036%22%20target%3D%22_blank%22%3E%40butchpt6%3C%2FA%3E%26nbsp%3BThere%20are%20many%20ways%20to%20achieve%20this%2C%20all%20depending%20on%20how%20your%20data%20is%20structured.%20You%20write%20about%20%22the%20very%20basic%20picture%20......%20above%22.%20If%20you%20intended%20to%20upload%20a%20screenshot%2C%20it%20did%20not%20come%20through.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20workbook%20contains%20two%20simplistic%26nbsp%3Bexamples.%20One%20using%20AVERGAGEIF%20and%20the%20other%20one%20uses%20a%20Pivot%20Table.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20mention%20that%20you%20want%20results%20to%20go%20to%20separate%20tables%20and%20separate%20sheets%20for%20each%20week.%20Probably%20not%20the%20best%20way%20to%20go%2C%20I%20think.%20But%20if%20you%20could%20upload%20an%20example%20of%20the%20data%20you%20collect%20(delete%20any%20confidential%20information%2C%20though)%20and%20the%20kind%20of%20results%20you%20would%20like%20to%20see%2C%20it%20would%20be%20much%20easier%20to%20come%20up%20with%20a%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
Ok, bare with me as i may not explain this very well

In the very basic picture i have 3 seperate values for which i want the averages for, however i want them for the different Managers above

For instance if Terry runs Friday and Saturday i woukd like to know his average result for all Values, and for that result to go into a seperate table

Also the shift managers will change every week (for which id use a seperate tab)

Is it possible and have i made myself clear?

Thanks
1 Reply
Highlighted

@butchpt6 There are many ways to achieve this, all depending on how your data is structured. You write about "the very basic picture ...... above". If you intended to upload a screenshot, it did not come through.

 

Attached workbook contains two simplistic examples. One using AVERGAGEIF and the other one uses a Pivot Table. 

 

You mention that you want results to go to separate tables and separate sheets for each week. Probably not the best way to go, I think. But if you could upload an example of the data you collect (delete any confidential information, though) and the kind of results you would like to see, it would be much easier to come up with a solution.