RE: Logical expressions in SUMIF criteria

["Phillip Shelton" <shelton usq edu au>]

How about sumif(a6:a20,10)+sumif(a6:a20,20)

will not work if you want AND.

-----Original Message-----
From: Terry Bolands [mailto:tbolands yahoo com]
Sent: Saturday, 24 August 2002 2:32 AM
To: gnumeric-list gnome org
Subject: Logical expressions in SUMIF criteria 


Hi,

I'm trying to do something like this:

SUMIF(A6:A20, OR("=10", "=20"),)

i.e. using a logical function in the criteria.  I'm
having trouble
getting the desire results.  Can anyone offer some
guidance?

TIA,
tb



__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list