| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
shorten formula
Roger Govier wrote...
.... =SUM(First:Last!A1) Of course, the sheet with the formula must be outside of the "sandwich" created by First and Last. .... No it doesn't. The only restriction on this particular formula is that it can't be in cell A1 in any of the worksheets between First and Last, inclusive, without causing circular recalc. It'd work just fine entered into any other cell. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dragging a formula | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Shorten sumproduct formula | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
