| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif referring to range names formulas not updating
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif referring to range names formulas not updating
Are you using array formulas?
If so, they have to be entered by hitting CTRL+SHIFT+ENTER. -- Brevity is the soul of wit. "Excel_Still_Stumps_ME" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic range name | Excel Discussion (Misc queries) | |||
| Macro to copy range of formulas to equal data lines | Excel Worksheet Functions | |||
| range names | Excel Worksheet Functions | |||
| range names | Excel Worksheet Functions | |||
| range names | Excel Worksheet Functions | |||
Linear Mode
