| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formulas
why does my formula change when I add data example =COUNTIF(D9:D6369,33) TO
=COUNTIF(D242:D6369,46) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas
why does my formula change when I add data example
=COUNTIF(D9:D6369,33) TO =COUNTIF(D242:D6369,46) In Excel's built-in Help, there's a topic: "About cell and range references" In that topic, there's a paragraph on "The difference between relative and absolute references" Maybe that'll help. If not, please provide more details about what actions are causing what changes for you. |
| 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 | |||
| Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| Excel formulas | Excel Worksheet Functions | |||
| IF/AND formulas within excel | Excel Discussion (Misc queries) | |||
Linear Mode
