SUM Formula

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?
 
G

Guest

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

cell does not recalc 3
Warning when in another cell after entering a formula. 2
auto calc on, but have to edit (f2) cells to force re-calc..help! 3
IF formula, Partial word, SUM function as result 1
Items in Workbook won't calc 2
how can I start and stop a sum formula? 1
How can I edit the formula without changing the format? {=SUM(if. 1
If a cell contains a value then sum another cell. 3

Top