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 <a...@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 > _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
