ExcelBanter - using indirect within a sum()

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - using indirect within a sum() (https://www.excelbanter.com/excel-discussion-misc-queries/259769-using-indirect-within-sum.html)

Rick

using indirect within a sum()

Why do I get "Cannot find Project or Library"?

=SUM(P4:INDIRECT("P"&ROW()-1))

Pete_UK

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))

Bernie Deitrick

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))

Rick

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))

.

All times are GMT +1. The time now is 04:50 AM.