Posts by Marcus Felipy Glatz Rodrigues • 11 points

• 0

  votes

  3

  answers

  42

  views

  A: Average function in excel

  I got what I wanted. For example average for a range of A1:A5, after that, A6:10 and so on, we can thus use the formula: =AVERAGE(OFFSET($A$1,(ROW(A1)-1)*5,0,5))

  excel formatting

  answered 3 years, 7 months ago Marcus Felipy Glatz Rodrigues 11

• 0

  votes

  3

  answers

  42

  views

  Q: Average function in excel

  I need to insert the average function in excel in ranges. For example, from A1:A5, just after A6:A10, A11:15 and so on. How do I make excel understand this logic? I thought to make him understand…

  excel formatting

  asked 3 years, 7 months ago Marcus Felipy Glatz Rodrigues 11