Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Averaging every 4 rows

Hello,
I have values for 15 min for 3 years. I need to make an hour average of 4 15 min rows.
I couldn't find topic related to this so I'm asking for help.

Thank you in advance

Need Help

4 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    Anonymous ,

    Did not got your problem, Could you explain it more in detail with some sample data?

    Thanks,

    Arul

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Sure!
      I need to get average number of every 4 rows and create another column with those average numbers.

        A         B

      1.121.205
      1.111.795
      1.09 
      1.5 
      1.78 
      2 
      2.1 
      1.3 

       

      B1 = AVERAGE(A1:A4)
      B2 = AVERAGE(A5:A8) and so on...
      Thank you so much for replying. ğŸ™‚