Hi

You need to wrap it in an indirect function itself for Sum to return the
answer.

=SUM(INDIRECT((ADDRESS(B2,COLUMN(B6))&":"&ADDRESS( B3,COLUMN(B6)))))

But you would have fewer calls it you did it directly (well indirectly
really<bg) with

=SUM(INDIRECT("B"&B2&":B"&B3)) note the colon before the second B

--
Regards

Roger Govier

Thanks for the fix Roger. I'll be using the top one as I need to fill across
columns.

Kevin