Sumif referring to range names formulas not updating

G

Guest

I have several sheets rolling into a summary sheet. The data is by location
and data type. Using SUMIF referring to range names to get the numbers in
the right place. My formulas are not updating automatically though automatic
calculation is selected in Options.

In order to update the formulae, must go through each cell and F2 [ENTER].

I tried F9 and all the variations of F9 - does not work.

Anyone know what's wrong?
 
G

Guest

Are you using array formulas?

If so, they have to be entered by hitting CTRL+SHIFT+ENTER.
 
G

Guest

Are you using array formulas?

If so, they have to be entered by hitting CTRL+SHIFT+ENTER.
 

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

Formulas do not update 2
Formulas not updating 1
Help!Excel will not calculate formulas- Not in manual calculation 6
EXCEL07 CELL FORMULAS WILL NOT COMPUTE TO A VALUE 2
Workbook Calculations set to Automatic - Excel 2007 2
Linked values not updating 3
vlookup and subtotal formulas not updating 2
My sumif formulas containin links to other workbooks do not calcul 4

Top