Re: how to compute totals grouped by field?

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?


gnumeric-list mailing list
gnumeric-list gnome org

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]