SUM Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several SUM formulas that sum across numerous sheets (Example -
=SUM('Placeholder Sales A:Placeholder Sales B'!H8)). The problem is that they
will not recalculate. The Calc is on but the only way I can get them to calc
is to hit f2 while in the SUM cell and then hit Enter. Does anyone know why
they won’t recalc?
 
I've been in Excel for many years so I'm checked all the Calculation Options.
It's on Automatic and F9 and Shift-F9 will not cause the SUM to calculate.
Plus, all other formlas are working.
 

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

Warning when in another cell after entering a formula. 2
cell does not recalc 3
IF formula, Partial word, SUM function as result 1
auto calc on, but have to edit (f2) cells to force re-calc..help! 3
Making an excel sheet so formulas can not be deleted in the sum to 2
How can I edit the formula without changing the format? {=SUM(if. 1
Array formulae do not recalculate 2
how can I start and stop a sum formula? 1

Back
Top