Re: Cell Indirect Reference Question

[Morten Welinder <mwelinder gmail com>]

> =sumif($D$1:$D&INDIRECT('G3'),"="&$F5,$B$1:$B$296)

You need to put the whole range into indirect.

=sumif(INDIRECT("d1:d"&g3),...)

Note, that "d1" is now inside a string and therefore will not change
if you insert
or delete a column.

Morten