| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drag formula
Does anyone know how to solve this problem I'm having.....
I type this sum in a cell =COUNTIF($A$18:$A$100, A3) I then drag the formula down. It only works in the other cells if I click in the cell (or F2) then out again. It does not automatically work when dragged down. Is this a formatting thing?? thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drag formula
Hi,
Try, Tools|Options|Calculation tab Set calculation to automatic. Mike "Fiona" wrote: Does anyone know how to solve this problem I'm having..... I type this sum in a cell =COUNTIF($A$18:$A$100, A3) I then drag the formula down. It only works in the other cells if I click in the cell (or F2) then out again. It does not automatically work when dragged down. Is this a formatting thing?? thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drag formula
thank you mike, it was on automatic, but i switched it to manual then back to
automatic and it works so must have been something to do with that thanks! "Mike H" wrote: Hi, Try, Tools|Options|Calculation tab Set calculation to automatic. Mike "Fiona" wrote: Does anyone know how to solve this problem I'm having..... I type this sum in a cell =COUNTIF($A$18:$A$100, A3) I then drag the formula down. It only works in the other cells if I click in the cell (or F2) then out again. It does not automatically work when dragged down. Is this a formatting thing?? thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does when i drag a formula in excel gives the same value? | Excel Worksheet Functions | |||
| What a drag - changing the formula | Excel Worksheet Functions | |||
| Drag formula down | Excel Worksheet Functions | |||
| Drag Formula Until ( ) | Excel Discussion (Misc queries) | |||
| How do i "drag" a formula? | New Users to Excel | |||
Linear Mode
