Excel: calcualte the avarage every 9 cell


Hallo everybody, I have a row with 9 (different) variables repeating 365 times. I have to calculate the avarage of each variable, over 365 times. the example is for an hypotetical case of a row with 3 different variables repeating 365 times. I have

A1 B1 C1 D1 E1 F1 G1 H1 I1 L1 M1 N1
1 prod level price prod level price prod level price avarage prod avarage level avarage price
2 p1 l1 pr1 ... ... ... p365 l365 pr 365 avarage(price1, ..., price365) avarage(level1, ..., level365) avarage(pr1, ..., pr365)
I hope it's clear enough. Thanks a lot as usual:smile: Amanda


This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of August 31, 2014.


For more resources for Microsoft Excel