On Wed, Oct 19, 2005 at 05:03:30PM -0400, Jim Foltz wrote: > I posted this thru Google Groups, but it looks like no one has used the > list since last year. > > I want to use sumif on Sheet2 to select and sum values from Sheet1, but > all I get is #VALUE!. My function looks like: > > =sumif(Sheet1!A1:A5,A1,Sheet1!B1:B5) > > Sheet1 > A1:Foo B1:1 > A2:Bar B2:2 > A3:Foo B3:3 > A4:Bar B4:4 > A5:Baz B5:5 > > Sheet2 > A1:Foo B1:=sumif(Sheet1!A1:A5,A1,Sheet1!B1:B5) > > Not sure where the problem is.
There was a bug in some version of gnumeric. It has been fixed. See if you can pick up a copy of the 1.6.0 release that came out recently. _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
