# Re: conditional summing

• From: Erich Neuwirth <erich neuwirth univie ac at>
• To: Terry Bolands <tbolands yahoo com>, gnumeric-list gnome org
• Cc:
• Subject: Re: conditional summing
• Date: Mon, 17 Jan 2005 22:55:04 +0100

```Instead of
=sum(if(H7:H12="a",J7:J12))
you probably should do
=sum(if(H7:H12="a",J7:J12,0))
if should supply an output for FALSE conditions!

=sum(if(and(H7:H12="a",H7:H12="a"),J7:J12))
you can do
=sum(if(H7:H12="a",1,0)*if(H7:H12="a",1,0)*J7:J12))
(of course, having the same condition twice does not make sense)

Terry Bolands wrote:
```
```Can someone explain why this works:

=sum(if(H7:H12="a",J7:J12))

but this does not:

=sum(if(and(H7:H12="a",H7:H12="a"),J7:J12))

or how to get something similar to the latter working?

TIA,
TB

```
__________________________________ Do you Yahoo!? All your favorites on one personal page – Try My Yahoo! http://my.yahoo.com _______________________________________________
```gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list

```
```

--
Erich Neuwirth, Computer Supported Didactics Working Group