Can this formula be shortened?

How can I shorten below? You can see it is redundant but the only thing that changes is the number after 'PR'.

='H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR1'!$L$51+'H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR2'!$L$51+'H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR3'!$L$51+'H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR4'!$L$51+'H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR5'!$L$51+'H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR6'!$L$51+'H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR7'!$L$51+'H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR8'!$L$51+'H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR9'!$L$51

Hello,

if the sheets PR1 to PR9 are sitting next to each other with no other sheets in between, you can use

=sum('H:\Year 2011\NPM CONST\Sail Electric Inc - Casino Road & Rucker Ave\Pay Requests\[Invoices.xls]PR1:PR9'!$L$51)

cheers,

Provided the sheets are in the proper order, try:

Please Login or Register  to view this content.

Cheers,