Link to home
Start Free TrialLog in
Avatar of James Coats
James CoatsFlag for United States of America

asked on

Open Office Calc: Trouble using Average function

I am having trouble getting an “average” function to work across different excel sheets in Open Office.

In the sheet “RunningAverages” I need to get the average of cells from 52 weeks of data from sheet NorthNextBuilding that will come from cells B4, B55, B106 and so on until I go to the end of the 52 weeks of data. The average of these numbers need to show in cell B3 in sheet “RunningAverages”

I need to do this on all of the cells related to all the other cells under the column named “Sample” and for all of the other sheets as well. I know how to use the average function just not in this case.

I have attempted to construct a formula that way it seems like it should work and you can also see how I need to work as well.

Any suggestions??
WeathershieldWeaterhingTest.xlsx
ASKER CERTIFIED SOLUTION
Avatar of ltlbearand3
ltlbearand3
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of James Coats

ASKER

Thank you very much