Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula keeps altering by itself!
Hi, I am using the following Excel formula:
=COUNTA(C4:C3593) It is placed in cell C3. However, each night, I delete the cells from C4 to C1045, and elect to shift left. Then the formula all of a sudden becomes: =COUNTA(C1046:C3593) So is there any way to prevent it from changing like this? I want the formula to always be: =COUNTA(C4:C3593) Cells C4 to C1045 need to be counted, even if they were just shifted from the right column. Thanks for any help! Julie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |