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
Adam Dingle 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
On Sun, 2009-01-11 at 02:07 +1100, Hal Ashburner wrote:
Adam Dingle 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
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