| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with change to formula
This is the formula I am using and it works good....
=SUM(IF(ISERR(FIND("-",G15:G125)),,REPLACE(G15:G125,1,FIND("-",G15:G125),"")-LEFT(G15:G125,FIND("-",G15:G125)-1)+1)) I now need to extend down to cell G133 instead of G125 I have manually changed all the G125s to G133 but then it returns a zero What am I doing wrong? Also I am using the above formula for rows A -G can I just drag the formula across ? as I seem to remember in the past this didnt work. thanks -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i enter a formula in excel that will change a cell value | Excel Worksheet Functions | |||
| formula help to change row colour automatically by some conditions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
