From mboxrd@z Thu Jan 1 00:00:00 1970 Path: main.gmane.org!not-for-mail From: rb Newsgroups: gmane.emacs.help Subject: blank cells in ses range Date: 26 Nov 2004 16:11:39 -0500 Organization: PANIX Public Access Internet and UNIX, NYC Message-ID: NNTP-Posting-Host: deer.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1101503743 11869 80.91.229.6 (26 Nov 2004 21:15:43 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Fri, 26 Nov 2004 21:15:43 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Fri Nov 26 22:15:39 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 1CXnRL-0002fs-00 for ; Fri, 26 Nov 2004 22:15:39 +0100 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.33) id 1CXnab-0005pP-NI for geh-help-gnu-emacs@m.gmane.org; Fri, 26 Nov 2004 16:25:13 -0500 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!bloom-beacon.mit.edu!panix!not-for-mail Original-Newsgroups: gnu.emacs.help Original-Lines: 27 Original-NNTP-Posting-Host: panix5.panix.com Original-X-Trace: reader1.panix.com 1101503499 15761 166.84.1.5 (26 Nov 2004 21:11:39 GMT) Original-X-Complaints-To: abuse@panix.com Original-NNTP-Posting-Date: Fri, 26 Nov 2004 21:11:39 +0000 (UTC) User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 Original-Xref: shelby.stanford.edu gnu.emacs.help:126950 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:22352 X-Report-Spam: http://spam.gmane.org/gmane.emacs.help:22352 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. Thanks very much for any help, rb --