| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Not Updating when copied down
Hi
I have what hopefully is a simple question. I have a forumla: =IF(COUNTA(INDIRECT("D3:M3"))3,"Training",COUNTA( INDIRECT("D3:M3"))) That works perfectly, but when i copy it down, it doesnt update the cell numbers, eg: =IF(COUNTA(INDIRECT("D3:M3"))3,"Training",COUNTA( INDIRECT("D3:M3"))) =IF(COUNTA(INDIRECT("D4:M4"))3,"Training",COUNTA( INDIRECT("D4:M4"))) =IF(COUNTA(INDIRECT("D5:M5"))3,"Training",COUNTA( INDIRECT("D5:M5"))) I have made sure that workbook calculation is set to "Automatic" as well as i know thats the most common mistake. Can anyone help me? Thanks very much Danny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart updating in copied worksheets | Charts and Charting in Excel | |||
| I need a different formula that can be copied down | Excel Worksheet Functions | |||
| Copied formula produces unexpected copied results | New Users to Excel | |||
| Updating macros with copied worksheet information | Excel Discussion (Misc queries) | |||
| Updating references in copied excel work sheet | Excel Programming | |||
Threaded Mode
