Please do, it will be good to meet you.

Regards

Bob

"Richard Buttrey" wrote in
message ...
On Wed, 24 May 2006 22:56:41 +0100, "Bob Phillips"
wrote:

Richard,

It would be better to put the whole range (M15:M2033) in T1 and use

=SUMIF(mqs_col,$N14,INDIRECT("'Main Working Paper'!"&T1))

or if you want a variable last row somehow, then at least the letter
(M15:M)
and use

=SUMIF(mqs_col,$N14,INDIRECT("'Main Working Paper'!"&T1&"2033"))

just makes it easier to read and maintain.

Thanks Bob - (and Biff)

I see now my main mistake was to have the Indirect before the SumIf...
doh!

Good idea though about having the whole reference in T1.

Incidentally I hope to be going to the Excel conference in London in
July so I'll make a point of coming to say Hello.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________