On Feb 18, 2013 7:38 PM, "Chris Knadle" <[email protected]> wrote: > > On Monday, February 18, 2013 18:01:16, Jack Chastain wrote: > > On Mon, Feb 18, 2013 at 5:38 PM, Matthias Johnson < > ... > > You are correct in that I can't read an ods with an android. Never > > > > > tried as I typically save in office formats since many people wouldn't > > > know what an ods is. > > > > I know what odious is, but not ods. Unless the latter is the former. > > .ods = OpenDocument Spreadsheet.
I was being silly ;-) > > > Not sure anyone can help ;-) (Silly again!) >> - what I am trying to do is get an average of > > the data in a column above the row the data is on. The average bit is easy: > > "-=AVERAGE($D$3:D3)" - That will look odd on the first line, but when you > > drag it down - say 13 rows, it becomes "=AVERAGE($D$3:D13)" - which is > > exactly right for row 13 - but if the data in rows 4-13 isn't yet present > > (this is a mileage comparator/calculator, so until time passes, it won't > > be), I want to really say "If there is information provided in cell D2, > > then give me the average, otherwise give me 0" > > I've got an idea of how to deal with this. AVG = SUM / COUNT, so... instead > of using the AVERAGE function, use SUM(range) / COUNT(range) -- because the > COUNT function skips over empty cells. There's also a function to count the > number of empty cells, if you need it. > Ooo. Yeah - that makes sense. I will give that a try momentarily. I find myself waiting for my son's car to be looked at - good time to play with a spreadsheet. Thanks! JC
_______________________________________________ Mid-Hudson Valley Linux Users Group http://mhvlug.org http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug Upcoming Meetings (6pm - 8pm) Vassar College Feb 6 - Raspberry Pi Mar 6 - 10th Anniversary Meeting - Linux where you least expect it Apr 3 - Typography: Physical Art to Digital Art
