l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Sep 11 14:21

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] open office spreadsheet question - dereferencing
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] open office spreadsheet question - dereferencing

On Sat 11 Sep 04, 11:59 AM, Jeff Newmiller <jdnewmil@dcn.davis.ca.us> said:
> On Sat, 11 Sep 2004, Peter Jay Salzman wrote:
> > Hola,
> > 
> > I use a formula to compute the average homework score for a class, only using
> > the scores of people who turn in the assignment.  In other words, it doesn't
> > include people who get zero (I always give a point for turning in a piece of
> > paper since a tree had to die for the paper).
> > 
> >    SUM(B1:B14) / COUNTIF(B1:B14; ">0")
> > 
> > I have to change that B14 each semester, depending on the number of people in
> > the class.
> > 
> > Instead, if I were to put the number of students in another cell, say E40,
> > how could I dereference E40 and use it in the formula?   So, I'd like to do
> > something like:
> > 
> > 
> >    SUM(B1: *E40) / COUNTIF(B1:*E40; ">0")
> > 
> > where "*" is some kind of dereference operator.   How do I do this?
> AFAIK, you can't.  But what is to stop you from assuming you will never
> have more than, say, 100 students at a time?
>   SUM(B1:B100) / COUNTIF(B1:B100; ">0")
Aiieeee.  It's such a simple request!!!

I can't really do:

   SUM(B1:B100) / COUNTIF(B1:B100; ">0")

because I have test and lab statistics underneath the homework statistics.
Looks like I'll either have to move what's underneath to a different page
to use your suggestion (and figure out how to form a grade from numbers on
different pages) or just grin and bear it with changing the ending student
row each semester.

Ah well!


Make everything as simple as possible, but no simpler. -- Albert Einstein
GPG Instructions: http://www.dirac.org/linux/gpg
GPG Fingerprint: B9F1 6CF3 47C4 7CD8 D33E 70A9 A3B9 1945 67EA 951D
vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
O'Reilly and Associates
For numerous book donations.