Autofill only copying initial value, not filling formula

  • Thread starter Thread starter dwbmd2005
  • Start date Start date
D

dwbmd2005

When I have tried to average columns of numbers with the formula
=Average(A1:A10). The initial value is correct, but when I try to autofill
across the row to get averages for each column, it simply copies the first
average. The formulas are actually correct when it fills but I need to
click on the cell ranges in each individual formula for it to recalculate the
averages correctly. Previously, everything was working fine.
 
Do you have manual calculation on?

Try hitting F9 to do a manual calculation this will recalc all cells at once.
 

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

Need help finding a soution for Excel formula 2
#DIV/0! ERROR 2
Average formula where blank cells are counted as zeros 4
Sumproduct in matrix means 3
conditional formula 10
Average of time spent monthly getting DIV/0 error 2
Finding the weighted average of text that have been given values 1
Help requested for nested conditional formulas referencing other c 3

Back
Top