From mboxrd@z Thu Jan 1 00:00:00 1970 Path: main.gmane.org!not-for-mail From: rb Newsgroups: gmane.emacs.help Subject: Re: blank cells in ses range Date: 27 Nov 2004 16:49:14 -0500 Organization: PANIX Public Access Internet and UNIX, NYC 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 1101592243 5070 80.91.229.6 (27 Nov 2004 21:50:43 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Sat, 27 Nov 2004 21:50:43 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Sat Nov 27 22:50:37 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 1CYASj-0006KH-00 for ; Sat, 27 Nov 2004 22:50:37 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.33) id 1CYAc2-0003My-Kq for geh-help-gnu-emacs@m.gmane.org; Sat, 27 Nov 2004 17:00:14 -0500 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!bloom-beacon.mit.edu!panix!not-for-mail Original-Newsgroups: gnu.emacs.help Original-Lines: 38 Original-NNTP-Posting-Host: panix5.panix.com Original-X-Trace: reader1.panix.com 1101592154 10337 166.84.1.5 (27 Nov 2004 21:49:14 GMT) Original-X-Complaints-To: abuse@panix.com Original-NNTP-Posting-Date: Sat, 27 Nov 2004 21:49:14 +0000 (UTC) User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 Original-Xref: shelby.stanford.edu gnu.emacs.help:126975 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:22378 X-Report-Spam: http://spam.gmane.org/gmane.emacs.help:22378 Alan Mackenzie writes: > rb wrote on 26 Nov 2004 16:11:39 -0500: > > 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. > > > Thanks very much for any help, > > Does it have to be an Emacs solution? Thank you for the suggestion. Yes, though, I am trying to figure out how to make this work within ses/emacs. The example was extracted from what would be a much more extensive spreadsheet. My workaround is to specifically list all the cells: (ses+ E1 E2 E3 E4 E5 E6 E7 E8 E9) works, but I would like to find a way to exclude the empty cells from an ses-range. I believe this is meant to be possible, I simply fail to understand how to go about it. Thanks again, rb --