CODEWITHSUNDEEP
excelspreadsheet
Macca VIII
Macca VIII

Reputation: 25

how do I average three columns where the criteria changes each month..ie last three monthly data

I have three columns for each month. I need to average the value in the third column of each month for the last three entries. Can I write a formula that will select the last three entries in the designated range and calculate the average.? And to do this for multiple rows where the data may not be in the same columns? My level of skill in using Excel is very limited, but I am trying to learn, I would very much appreciate any help that may be forthcoming.

Upvotes: 0

Views: 154

Answers (1)

ioMatrix
ioMatrix

Reputation: 633

You can use the AVERAGE() function in a cell on the same row. The arguments for the function will be the cells you wish to average.

Can be a series of cells (A1,B1,C1....) or a range (A1:C1). If you use cells from all over the spreadsheet. The copy function uses the relative position by default.

Once you have the function working in a particular row, you may copy that formula down to the other rows in the spreadsheet. Excel will automatically change the formula to include the corresponding cells from the same row the formula is being copied to.

For additional info on this function, visit:

http://office.microsoft.com/en-ca/excel-help/average-function-HP010062482.aspx

Upvotes: 1

Related Questions