| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
So old that it should have been second nature to me...
In article . com, "Harlan Grove" wrote: =-SUM(-B1,C1:D1) will avoid the need for array entry and will only fail to ignore text in B1. This is an old (REAL OLD) 123 trick. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rotate a box with a cell's contents | Excel Discussion (Misc queries) | |||
| Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
| Delete contents of unprotected cells in workbook | Excel Worksheet Functions | |||
Threaded Mode
