Home

Find specific name and average numbers in that row and multiple rows

%3CLINGO-SUB%20id%3D%22lingo-sub-328008%22%20slang%3D%22en-US%22%3EFind%20specific%20name%20and%20average%20numbers%20in%20that%20row%20and%20multiple%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-328008%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3ESituation%3C%2FSTRONG%3E%3A%20I%20have%20a%20Microsoft%20Form%20that%20is%20filled%20out%20by%20teachers%20to%20document%20student%20behaviors%20(up%20to%2050%20students)%20to%20find%20trends%20and%20correct%20their%20behavior%20over%20time.%20The%20results%20from%20the%20Form%20populate%20in%20an%20Excel%20spreadsheet%20in%20my%20OneDrive%20(the%20Form%20was%20created%20in%20my%20OneDrive%20%26gt%3B%20Forms%20for%20Excel).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71449iF10515CAB11F2728%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-01-30%2009_41_12-Window.png%22%20title%3D%222019-01-30%2009_41_12-Window.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EWhat%20I'm%20looking%20to%20do%3C%2FSTRONG%3E%3A%20I%20would%20like%20to%20calculate%20the%20average%20of%20%3CEM%3Eevery%20row%3C%2FEM%3E%20for%20a%20specific%20student%20under%20the%20column%20headings%20(Pride...%2C%20Academic...%2C%20Working...%2C%20Safe...)%20for%20every%20time%20a%20Form%20is%20filled%20out%20for%20that%20student.%20I%20have%20a%20sheet%20in%20this%20spreadsheet%20to%20gather%20this%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20291px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71450i04E3975D9B8F2A0A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%222019-01-30%2009_41_27-Window.png%22%20title%3D%222019-01-30%2009_41_27-Window.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EThoughts%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CUL%3E%3CLI%3EI%20looked%20into%20using%20the%26nbsp%3B%3CSTRONG%3Evlookup%3C%2FSTRONG%3E%20and%26nbsp%3Bdifferent%26nbsp%3B%3CSTRONG%3Eaverage%3C%2FSTRONG%3E%20formulas.%20Not%20sure%20if%20I%20need%20to%20use%20a%20combination%20of%20those.%3C%2FLI%3E%3CLI%3EI%20will%20be%20getting%20Form%20submissions%20daily%20on%20all%20of%20these%20students%20so%20I%20will%20need%20these%20averages%20to%20be%20constantly%20updating.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E*Attached%20is%20a%20copy%20of%20the%20spreadsheet%20I'm%20working%20on%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-328008%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Aaron Sweet
Regular Visitor

Situation: I have a Microsoft Form that is filled out by teachers to document student behaviors (up to 50 students) to find trends and correct their behavior over time. The results from the Form populate in an Excel spreadsheet in my OneDrive (the Form was created in my OneDrive > Forms for Excel).

 

2019-01-30 09_41_12-Window.png

 

What I'm looking to do: I would like to calculate the average of every row for a specific student under the column headings (Pride..., Academic..., Working..., Safe...) for every time a Form is filled out for that student. I have a sheet in this spreadsheet to gather this data.

 

2019-01-30 09_41_27-Window.png

 

Thoughts:

  • I looked into using the vlookup and different average formulas. Not sure if I need to use a combination of those.
  • I will be getting Form submissions daily on all of these students so I will need these averages to be constantly updating.

*Attached is a copy of the spreadsheet I'm working on

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies