How do I average row of cells when another row of cells is within given values?

%3CLINGO-SUB%20id%3D%22lingo-sub-1313983%22%20slang%3D%22en-US%22%3EHow%20do%20I%20average%20row%20of%20cells%20when%20another%20row%20of%20cells%20is%20within%20given%20values%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1313983%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20average%20row%20of%20cells%20when%20another%20row%20of%20cells%20is%20within%20given%20values%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1313983%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1314329%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20average%20row%20of%20cells%20when%20another%20row%20of%20cells%20is%20within%20given%20values%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1314329%22%20slang%3D%22en-US%22%3EKindly%20attach%20a%20sample%20file%20for%20better%20understanding%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

How do I average row of cells when another row of cells is within given values?

3 Replies
Kindly attach a sample file for better understanding
Highlighted
Highlighted

@Abiola1 

I have some of what I want, but I would like to have when I input the values in the temp 1 cell it automatically populates the delta.