Excel Sum Formulas - maybe all??
xanthippe09 wrote...
I just got set up with Office 2007. I was creating some spreadsheets
and found that I can't just copy formulas over. I fill in a sum
formula, and then drag the content over and it changes the cell range
okay, but it doesn't update the amount. Also, if I change the numbers
within the formula it doesn't update the total. Is there something
I've done wrong?
Press [F9] to see if that produces the correct results. If it does,
your problem is that Excel is set for manual recalculation. And, very
unfortunately, that means you have to wade through Excel 2007's much
less efficient Options dialog. I don't have Excel 2007, so I can't
give you the steps to follow, but you should be able to find out using
Excel online help, searching for the term Calculation.
|