|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 24th, 2010, 03:20 PM
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
March 24th, 2010, 03:28 PM
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
March 24th, 2010, 04:41 PM
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
March 24th, 2010, 07:56 PM
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)) .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
