Re: Cell Indirect Reference Question

[Morten Welinder <mwelinder gmail com>]

On 6/10/05, Jason A. Pfeil <jason jasonpfeil com> wrote:
> Morten,
>
> How about if I wanted the starting part of the range to be indirect as
> well?  Such as the below.
>
> =sumif(indirect("$D"&$I$3":$D"&$I$4),"="&$H6,indirect("$B$1:$B$"&$I$4))

INDIRECT doesn't care where the string comes from, but it looks like you
are missing an "&" before quote-colon.

Morten