From mboxrd@z Thu Jan 1 00:00:00 1970 Path: main.gmane.org!not-for-mail From: Stefan Monnier Newsgroups: gmane.emacs.help Subject: Re: blank cells in ses range Date: Sat, 27 Nov 2004 22:08:46 GMT Message-ID: References: NNTP-Posting-Host: deer.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1101593444 8624 80.91.229.6 (27 Nov 2004 22:10:44 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Sat, 27 Nov 2004 22:10:44 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Sat Nov 27 23:10:38 2004 Return-path: Original-Received: from lists.gnu.org ([199.232.76.165]) by deer.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1CYAm5-0007I2-00 for ; Sat, 27 Nov 2004 23:10:38 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.33) id 1CYAvO-0008KT-Vf for geh-help-gnu-emacs@m.gmane.org; Sat, 27 Nov 2004 17:20:15 -0500 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!logbridge.uoregon.edu!snoopy.risq.qc.ca!charlie.risq.qc.ca!53ab2750!not-for-mail Original-Newsgroups: gnu.emacs.help User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/21.3.50 (gnu/linux) Cancel-Lock: sha1:YxxOtxN5gE9StJuCrntZtHEIuzM= Original-Lines: 27 Original-NNTP-Posting-Host: 132.204.24.84 Original-X-Complaints-To: abuse@umontreal.ca Original-X-Trace: charlie.risq.qc.ca 1101593326 132.204.24.84 (Sat, 27 Nov 2004 17:08:46 EST) Original-NNTP-Posting-Date: Sat, 27 Nov 2004 17:08:46 EST Original-Xref: shelby.stanford.edu gnu.emacs.help:126978 Original-To: help-gnu-emacs@gnu.org X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: main.gmane.org gmane.emacs.help:22381 X-Report-Spam: http://spam.gmane.org/gmane.emacs.help:22381 > I'm having difficulty understanding how to eliminate "empty" or "blank" > cells when performing a simple sum calculation on a range in > ses21-031130, and I would be very grateful for any assistance. > What I would like is the sum of, say, Column "E", which has rows 1 - 10, > of which approx. half are empty. > E > 1 41 > 2 11 > 3 > 4 9 > 5 > 6 20 > 7 > 8 > 9 15 > 10 96 > What I would like is for E10 to be (apply '+ (ses-range E1 E9)), with > the empty cells simply eliminated from the calculation. I can't figure > out how to make (ses+ &rest ARGS) work with the range calculation. Have you tried (apply 'ses+ (ses-range E1 E9)) ? Stefan