On May 20, 9:47*pm, Pete_UK wrote:
Put this in C6:

=SUM(INDIRECT("'BDM"&TEXT(ROW(A1),"000")&"'!M:M"))

then copy it down as required.

Hope this helps.

Pete

On May 20, 9:17*pm, robzrob wrote:



I've got =SUM(BDM001!M;M) in C6, ie referring to column M in worksheet
BDM001. *In C7, I want =SUM(BDM002!M:M0, ie referring to worksheet
BDM002, in C8 I want =SUM(BDM003!M:M), etc. *How do I copy down?- Hide quoted text -

- Show quoted text -

Thanks Pete - It works. Don't suppose you'd care to explain, would
you? I'm inexperienced and can't work out why it works!