Re: sumif between sheets

[Jody Goldberg <jody gnome org>]

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.