SOLVED

Help with function average

%3CLINGO-SUB%20id%3D%22lingo-sub-2280091%22%20slang%3D%22en-US%22%3EHelp%20with%20function%20average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280091%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%2C%20I'm%20needing%20to%20create%20a%20sequence%20of%20averages.%20for%20example%2C%20I%20need%20the%20first%20to%20go%20from%20A1%3A%20A5%2C%20right%20after%20A6%3A%20A10%2C%20A11%3A%20A15%20....%20How%20do%20I%20get%20Excel%20to%20understand%20this%20formatting%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2280091%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280678%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20function%20average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280678%22%20slang%3D%22en-US%22%3EYou're%20welcome%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032663%22%20target%3D%22_blank%22%3E%40Marcus1997%3C%2FA%3E!%20Glad%20it%20worked%20as%20desired.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280509%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20function%20average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280509%22%20slang%3D%22en-US%22%3EThanks%20for%20your%20help.%20It%20was%20very%20efficient%20for%20me.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2280139%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20function%20average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2280139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1032663%22%20target%3D%22_blank%22%3E%40Marcus1997%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20try%20something%20like%20this...%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DAVERAGE(OFFSET(%24A%241%2C(ROW(A1)-1)*5%2C0%2C5))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20then%20copy%20it%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Please, I'm needing to create a sequence of averages. for example, I need the first to go from A1: A5, right after A6: A10, A11: A15 .... How do I get Excel to understand this formatting?

3 Replies
best response confirmed by Marcus1997 (New Contributor)
Solution

@Marcus1997 

You may try something like this...

=AVERAGE(OFFSET($A$1,(ROW(A1)-1)*5,0,5))

and then copy it down.

Thanks for your help. It was very efficient for me.
You're welcome @Marcus1997! Glad it worked as desired.