Re: Cell Indirect Reference Question
- From: Morten Welinder <mwelinder gmail com>
- To: jason pfeil gmail com
- Cc: gnumeric-list gnome org
- Subject: Re: Cell Indirect Reference Question
- Date: Fri, 10 Jun 2005 12:46:02 -0400
=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
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]