# Re: how to compute totals grouped by field?

• From: Hal Ashburner <hal ashburner gmail com>
• Cc: gnumeric-list gnome org
• Subject: Re: how to compute totals grouped by field?
• Date: Sun, 11 Jan 2009 02:07:08 +1100

```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 all
payments ever made to that vendor:

XyzCo  6.40
AbcCo  8.20
...

Is this possible in Gnumeric?
```
```Yes, there are a couple of ways to do this.
One way is to enter an array function to conditionally sum.
if XyzCo is in cell A7, and other companies below then this formula:

=sum(if(\$A7=\$B\$1:\$B\$3,\$C\$1:\$C\$3,0))
which you enter using ctrl+shift+enter so it will then appears like this:
{=sum(if(\$A7=\$B\$1:\$B\$3,\$C\$1:\$C\$3,0))}(1,1)[0][0]

will do the job. This also works in competing spreadsheet packages so is
quite portable.
```
```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?

```