| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average the Last Five Cells in a Column
I have some numbers in a column and I want to take the average of the last
five. If my numbers are in A1:A10 I know I can use the AVERAGE function: AVERAGE(A6:A10). But the problem is that some of the cells are empty. What I want to do is take the average of the last five cells in a column, so long as those cells have numbers in them. So if cell A7, for example, is empty, I would average A5:A10. If A7 and A8 are empty, I would average A4:A10. Is there any way that this is possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I pivot a range of cells, i.e. from column to row? | Excel Discussion (Misc queries) | |||
| In a column of text data, how do I delete random cells that have . | Excel Discussion (Misc queries) | |||
| Copy cells to another column with VBA | Excel Discussion (Misc queries) | |||
| Help adding text values | Excel Worksheet Functions | |||
| how do I find an average number of specific words in a column | New Users to Excel | |||
Threaded Mode
