R
Rick
Why do I get "Cannot find Project or Library"?
=SUM(P4:INDIRECT("P"&ROW()-1))
=SUM(P4:INDIRECT("P"&ROW()-1))
P
Pete_UK
Try it this way:
=SUM(INDIRECT("P4
"&ROW()-1))
Hope this helps.
Pete
=SUM(INDIRECT("P4
"&ROW()-1))Hope this helps.
Pete
B
Bernie Deitrick
Why not just
=SUM($P$4???)
replace the ??? with the row -1 of the cell with the formula.
HTH,
Bernie
MS Excel MVP
=SUM($P$4
???)replace the ??? with the row -1 of the cell with the formula.
HTH,
Bernie
MS Excel MVP
R
Rick
Thank Pete no more error messages,
Pete_UK said:Try it this way:
=SUM(INDIRECT("P4
Hope this helps.
Pete
.