Auto Average on next free cell

  • Thread starter Thread starter markso.fuji
  • Start date Start date
M

markso.fuji

Ive got a worksheet, that i need the following to be done.

Ive been trying all morning to no avail!!

Start at the cell i have currently selected.

Work out the average of all that is above it, up to the next empty
cell. (Like Auto Sum)
Enter the average into the cell.
Move to the next free cell.
Work out the average of all that is above it, up to the next empty
cell.(Like Auto Sum)
Enter the average into the cell.

and so on.

Its doing my nut in, so all help appreciated.

Mark.
 
If data consists of all values separated by blanks, try:

1. Edit > Goto > Special > Blanks
2. Auto Sum button (Alt =).
3. Edit > Replace "Sum" with "Average".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging only populated cells 6
#DIV/0! ERROR 2
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Trying to find additional ranges outside of min, max, and average 2
Formula for average of cells that have blanks 1
Average per block 4
Sum of 12 cells 7
Consistantly average 180 data cells 9

Back
Top