Re: how to compute totals grouped by field?

["Uri David Akavia" <uridavid akavia gmail com>]

How about doing SUMIF, which is also compatible with all other vendors?

SUMIF(Range, criteria, sum column)

For example, in your case, you would do something like
SUMIF(B:B, "XyzCo", C:C)

On Sat, Jan 10, 2009 at 4:03 PM, Adam Dingle <adam medovina org> wrote:
> In Gnumeric, suppose that I have a series of rows representing payments to
> vendors.  Each row contains a date, a vendor name and a payment:
>
> 4/3   XyzCo   4.15
> 4/4   AbcCo   8.20
> 4/5   XyzCo   2.25
> ....
>
>
> I'd like to construct a table showing each vendor and the total of all
> payments ever made to that vendor:
>
> XyzCo  6.40
> AbcCo  8.20
> ...
>
>
> Is this possible in Gnumeric?  Or must I export to an SQL database and
> execute a query such as 'select sum(payment) GROUP BY vendor', which would
> have a similar effect?
>
> adam
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list