> =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
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
