conditional summing

From: Terry Bolands <tbolands yahoo com>
To: gnumeric-list gnome org
Subject: conditional summing
Date: Mon, 17 Jan 2005 11:43:09 -0800 (PST)

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

Follow-Ups:
- Re: conditional summing
  - From: Erich Neuwirth

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