| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using indirect within a sum()
Why do I get "Cannot find Project or Library"?
=SUM(P4:INDIRECT("P"&ROW()-1)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using indirect within a sum()
Try it this way:
=SUM(INDIRECT("P4:P"&ROW()-1)) Hope this helps. Pete On Mar 24, 3:20*pm, Rick wrote: Why do I get "Cannot find Project or Library"? =SUM(P4:INDIRECT("P"&ROW()-1)) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using indirect within a sum()
Why not just
=SUM($P$4:P???) replace the ??? with the row -1 of the cell with the formula. HTH, Bernie MS Excel MVP "Rick" wrote in message ... Why do I get "Cannot find Project or Library"? =SUM(P4:INDIRECT("P"&ROW()-1)) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using indirect within a sum()
Thank Pete no more error messages,
"Pete_UK" wrote: Try it this way: =SUM(INDIRECT("P4:P"&ROW()-1)) Hope this helps. Pete On Mar 24, 3:20 pm, Rick wrote: Why do I get "Cannot find Project or Library"? =SUM(P4:INDIRECT("P"&ROW()-1)) . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Indirect Sum | Excel Worksheet Functions | |||
| Use of 'INDIRECT | Excel Worksheet Functions | |||
| INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
| Need help with Indirect | Excel Discussion (Misc queries) | |||
Linear Mode
