l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
October 7: Social gathering
Next Installfest:
TBD
Latest News:
Aug. 18: Discounts to "Velocity" in NY; come to tonight's "Photography" talk
Page last updated:
2001 Dec 30 16:58

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] star office question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] star office question


  • Subject: Re: [vox-tech] star office question
  • From: jdnewmil@dcn.davis.caMAPS.us
  • Date: Wed, 22 Nov 2000 17:16:12 -0800
  • References: Pine.LNX.4.21.0011221654530.29530-100000@belial.ucdavis.edu

On Wed, 22 Nov 2000, Peter Jay Salzman wrote:

> concerning the spreadsheet...
> 
> how do you take the average of a range of cells, without taking any 0's into
> account?
> 
> so if
> 
> A1  1
> A2  1
> A3  1
> A4  1
> A5  0
> 
> AVERAGE(A1:A5) yields 1.0, not .8.

You got a problem, man? Equal Rights For Zeroes! Zero Is Not A Null Value!

One way is to set up a second column that tests each value "=IF(A1=0,0,1)"
and adds those up, you can divide that into SUM(A1:A5) to get your answer.

Most spreadsheets were developed and used by people who never heard of
the concept of a null value (not zero, drops out of AVERAGE
function) which is common in databases.  Thus, a blank cell seems to count
as zero if it is empty.

I don't have StarOffice available at the moment, but Excel recently added
a "DAVERAGE" function that could be abused to do what you want, so SO
might have it too.

---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil@dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
Work:<JeffN@endecon.com>              Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...2k
---------------------------------------------------------------------------


LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
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.