Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Hi,
I have tried coping formulas in other cells. But it is acting like it does not read them. Some columns work and others don't. I can't even sum the column, it reads 0. Other columns total. I exported some information from quickbooks to excel, just adding other columns but it will not allow this. -- dawnrenae |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Hi,
It could be that some of the cells that contain the formula are formatted as 'Text' Select a cell and Re-format as general, Tap f2 and enter and see what happens. Mike "dawnrenae" wrote: Hi, I have tried coping formulas in other cells. But it is acting like it does not read them. Some columns work and others don't. I can't even sum the column, it reads 0. Other columns total. I exported some information from quickbooks to excel, just adding other columns but it will not allow this. -- dawnrenae |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas
Switch between relative, absolute, and mixed references
1.. Select the cell that contains the formula. 2.. In the formula bar , select the reference you want to change. 3.. Press F4 to toggle through the combinations. The "Changes To" column reflects how a reference type updates if a formula containing the reference is copied two cells down and two cells to the right. Formula being copied Reference (Description) Changes to $A$1 (absolute column and absolute row) $A$1 A$1 (relative column and absolute row) C$1 $A1 (absolute column and relative row) $A3 A1 (relative column and relative row) C3 -- Don Guillett Microsoft MVP Excel SalesAid Software "dawnrenae" wrote in message ... Hi, I have tried coping formulas in other cells. But it is acting like it does not read them. Some columns work and others don't. I can't even sum the column, it reads 0. Other columns total. I exported some information from quickbooks to excel, just adding other columns but it will not allow this. -- dawnrenae |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |